Re: LONG delete with LOTS of FK's

On 2013-05-01 10:23, Shaun Thomas wrote:
> On 05/01/2013 10:17 AM, Larry Rosenman wrote:
>
>> I have an app that we have a number of tables that all have FK
>> relationships with the account table.
>
> OK so far.
>
>> Referenced by:
>>      * Redacted one-billion foreign keys
>
> Wow. I really hope every single one of those tables has an index on
> the listed column, and it's the same datatype (bigint). Otherwise,
> this is going to take a long, long time.
Yes, all of them have at least one index that has account_id as the
first column (we use that to
separate tenants in a multi-tenant app).

I still wonder if there is a way to see where it is :(


--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-642-9640 (c)     E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893