We have delete jobs which delete a lot of records belonging to one Version of data that runs for sometimes 2 days. The relation to this Dataversion is done by one Column in each Table whith the same value called Versionnumber. Lots of the tables are conected with cascaded deletes. How can I determine which Indexes on foreign Keys are needed to accelerate this job?
June 4, 2004 8:40 AM
June 7, 2004 7:05 AM