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?
No, I do not have indexes setup for those dependents.
If I setup index for those columns, it will speed up the deletion, right?
Thank you.
