Post reply

Scan And Seek(Index/table)

  • October 12, 2004 at 11:52 pm

    #60543

    Hi All,

     

    I want to know about the scan(Index/table) and seek methods , how they are differ in searching process?

     

    Thanks and Regards

    Ramesh K

     

  • October 13, 2004 at 6:46 am

    #526500

    Table Scan

    SQL processes all rows in the table looking for a match

    Index Scan

    SQL processes all rows in the index looking for a match

    Index Seek

    SQL processes the leaf layers and leaf nodes looking for a match

    Index seek is normally the most efficient but depends on indexes and data volumn. If sql determines that the query would be too costly for a seek it may revert to an Index or Table scan.

    Hope this helps.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply