SQL Server Performance

Clustered Index Scan Cost 98%...how to reduce ?

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Ankit shah, May 2, 2012.

  1. Ankit shah New Member

    Hi Guys..
    First time i am posting question here..
    Well Scenarios is: We have one report is running and taking very long time almost 8 to 10 min prod env. It's SELECT query which is running behind the report. when i saw in execution plan CLUSTERED INDEX SCAN is 98%.
    So how i can convert it to CLUSTERED INDEX SEEK? or
    what are the other steps can be to improve Query performance?

    Really appreciate for kind help.
    Thanks
    Ankit shah, May 2, 2012
    #1

  2. Luis Martin Moderator

    Welcome to the forums!
    That table does not have any cluster index?
    Luis Martin, May 2, 2012
    #2

  3. FrankKalis Moderator

    Welcome to the forums!
    You have provided very little information so far. It would be beneficial to provide at least the SELECT query in question and maybe some more information about the table(s), indexes, number of rows returned, number of rows in the table(s)...
    FrankKalis, May 2, 2012
    #3

Share This Page