Post reply

Index seeks

  • April 30, 2007 at 10:37 am

    #116962

    Hi Guys.. i'm trying to get an understanding of index

     

    Looking at the execution plan of a Query i wrote, i noticed a few index seeks and index scans.

    The index seeks range from 2-18% and a single Index scan of 1%, is this good regardless of the percentage?

    I have two seperate call functions in my query, wondering if this the reason why my query is performing a bit slow  average 10 secs to execute.

    By the way, the table of the query in these two functions has single index seeks of 100%, but the only has a query cost of 1% to the batch.

     

    Any thoughts or suggestions on this my friends ?

  • April 30, 2007 at 12:20 pm

    #703371

    Everything in the index plan should add up to 100%, so there will always be things with large percentages. Seeks are better than scans because you're traversing the index directly to the rows, not moving across other rows you don't need in a scan.

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

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