"Emi Lu" <emilu@xxxxxxxxxxxxxxxxx> 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
