September 29, 2003 at 10:18 pm
We find that SQL is taking a lot of time to delete (selective) records. Is there any effective way of deleting records in a table??
September 30, 2003 at 2:10 am
How is your table structured? What indexes do you have on the table? What is the statement your are using to delete the record?
If you have a single field clustered index and use that field as the selection criteria for your query, then the delete will be relatively quick. However, if you have a composite index, using that as you criteria will prove to be slower. The datatypes and ordering of the fields in the index can make a difference also.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
September 30, 2003 at 2:52 am
Thanks. I will check the indexes and the order of the fields.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply