Post reply

Non Clustered Index

  • April 2, 2013 at 5:19 am

    #276003

    Hi,

    One of my query (simple update query) with clustered index utilizing 98%. And then i added non-clustered index on the same table then its utilizing 25% [non-clustered Index] and 75% [Clustered Index].

    Is it good thing????

    Because development team people again saying query is very slow.

    How to resolve this issue. Pl. help on this.

    Thanks.

    Pradeep

  • April 2, 2013 at 5:31 am

    #1602742

    pradeep.mohan (4/2/2013)

    One of my query (simple update query) with clustered index utilizing 98%. And then i added non-clustered index on the same table then its utilizing 25% [non-clustered Index] and 75% [Clustered Index].

    Is it good thing????

    No idea. Those % are estimated percentages of the entire batch. Without knowing how expensive the entire batch is (or how wrong the estimates are) there's no way to say whether that's good or bad.

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

    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

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

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