Results 1 to 2 of 2

Thread: about Index

  1. #1
    Join Date
    Oct 2004
    Location
    Korea
    Posts
    9

    Unanswered: about Index

    Hi all~
    can anybody tell me What is the difference
    Index Seek AND Index Scan
    Thanks~

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by openmind
    Hi all~
    can anybody tell me What is the difference
    Index Seek AND Index Scan
    Thanks~
    Well, if our criterion is (LIKE 'A%'),we do one single lookup in our index and are able to look through the non-clustered index to find a continuous range of data.This kind of lookup where we can go to a particular spot in the index is called a Index Seek.
    You better see the BOL about this topic

    Index Seek
    Index scan
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •