Post reply

Clustered Index seek

  • November 25, 2009 at 1:34 pm

    #228177

    Hi everyone,

    I have a query which takes 30 to 50 sec to run which is not bad but in the execution plan i can see clustered index scan.I want to make it clustered index seek for better performance for that i did make sure to have atleast one clustered index on every table but still the table is scanning.can any one tell me how to get clustered index seek in execution plan .

  • November 25, 2009 at 2:34 pm

    #1084362

    Please post query, table definitions and index definitions, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Is the query predicate a left-based subset of the clustered index key?

    This series on indexes may be worth a read - http://www.sqlservercentral.com/articles/Indexing/68439/

    At least one clustered index? If you have more than one clustered index on a table I'd love to know how.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 25, 2009 at 2:43 pm

    #1084370

    GilaMonster (11/25/2009)

    At least one clustered index? If you have more than one clustered index on a table I'd love to know how.

    I don't remember when was the last time I laughed 5 minutes at a stretch, enough for today and tomorrow. :hehe: :cool::hehe::cool:

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

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

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