Home Forums Programming General How to speed up DELETE queries on MSSQL v7.0? RE: How to speed up DELETE queries on MSSQL v7.0?
Jonathan
SSC-Insane
Points: 20427
More actions
January 16, 2004 at 8:47 pm
#490576
Okay; it's probably the foreign keys. What indexes exist for the eight tables with foreign keys referencing the RetailMember table? What DRI options (e.g. CASCADE DELETE) exist for those constraints?
--Jonathan