Remove from tablename takes an abnormally long

Question

I have a table in sql server 2005 with a chaild table in which there are millions of records. Whenever I issue the delete command even with the where clause, it takes an abnormally long time to execute. Does it depend on the size of the child table that causes this delay? What are the ways to speed up query deletion?

Thanks, Sweta.

Answer 1

Usual suspects:

• Trigger?
• Column (column) index in a WHERE? Clause
• Pointer to FL columns in FK column of child table?
• Cascade delete, etc .: see index points.

also:

• does the log file grow?
• ...

Edit, after comments: you need indexes ...

Answer 2

, . , .