Deleting records

  • 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??

  • 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

  • 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