Re: delete is extremely slow

"Emi Lu" <emilu@encs.concordia.ca> wrote
> Hello,
>
> Tried to run:
>
> delete from tableA where id <600000;
>
> It is extremely slow.
>
> id is integer and also the primary key. tableA has around 90000 records.
>
> (I do not want to run truncate since I have some foreign key constraint
> setup based on tableA. Besides not all data I want to delete; only part
> of them).
>

Since you have some FK constrains on A, so delete each line of A will
confirm that it is not depended, which involves a lookup on the dependent
table. Do you have indexes built on these dependents?

Regards,
Qingqing