I have a table with primari key. which is refrenced across 63 columns in 40 + tables
Now when i tried to delete one record in this table it takes lot over 5 min to delete it.
is their batter way to optimize delete??
You probably have a large table or tables that have a foreign key reference to the table you are deleting from without an index on the FK column. In that case SQL Server has to scan the entire table to see if it is OK to delete the row. An index on the FK column would prevent the table scan.
Generally, you should have an index on a foreign key column. It is not created by default when you created a foreign key