Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2002
    Location
    California, US
    Posts
    21

    Question Unanswered: Help on Clustered index scan or index scan VS Clustered index seek or index seek

    Hi everone,
    I wish to know more about these index scan and index seek. I am doing an audit in a data base and stored procedure created by some one. Most of the stored procedure for selecting records, the devleopers written with COALESCE in where clause to make more option like NULL values.
    When I do query excution plan for the queires with COALESCE it is doing clustered index scan or index scan. If I remove COALESCE option, the query plan I can see clustered index seek or index seek.
    I hope clustered index seek or index seek is good way of doing query.
    All I need is more explanation for clustered index scan or index scan VS
    clustered index seek or index seek. Does any one can suggest the articles or white papers having this. Because the microsoft document is not explaining much or i may not looking in proper document.
    Any help.
    Thanks in advance
    Thazul.:cool:
    Last edited by thazanm; 07-24-02 at 19:46.

Posting Permissions

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