"Emi Lu" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
