Post reply

Logical reads has reduced but not execution time's?

  • March 3, 2011 at 10:37 am

    #247560

    i was able to bring down logical reads to half by creating a covering index, however the query took the same time to complete as it did before? What does this mean?

  • March 5, 2011 at 10:39 am

    #1295013

    One of the reasons could be that bottleneck is not in I/O.

  • March 6, 2011 at 12:49 am

    #1295070

    Would need to see the execution plan to help you on that one. You might try also checking waits on the spid while it runs to see if you can catch something odd.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

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

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