SQL Server Performance

Index seek not Index scan

Discussion in 'Performance Tuning for DBAs' started by krajdba, Apr 2, 2005.

  1. krajdba New Member

    Hi Gurus,

    How to force Sequel server engine to do Index Seek only and not Index scan.

    thanks

    raj
  2. derrickleggett New Member

  3. dineshasanka Moderator

    quote:Originally posted by krajdba

    Hi Gurus,

    How to force Sequel server engine to do Index Seek only and not Index scan.

    thanks

    raj

    There are many articles on this subject. just do a search on this

    You can use the Index Tunning Wizard for more help
  4. mmarovic Active Member

    Usualy by having proper condition on starting column of the index ( column > value, column < value, column = value column like 'someting%') and if you have more then one just and logical operations between.

    That's the most precise answer I can figure out based on no info provided for query that bothers you.

Share This Page