Krishna1 (2/20/2013)
Created index on foreign key tables , for key column of the base table. but no luck.
Not the Base Table, the Child Table needs an index on the columnthat refers to the Base Table. See, everytime a delete occurs the Engine needs to do a SELECT on the child table to ensure it is not orphaning any rows. If the column in the Child Table is not indexed that can be very detrimental to performance.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato