Post reply

Looking for table scan from profiler

  • July 21, 2006 at 8:42 am

    #61676

    I need to list out table scans from the results of a profiler output. I was going to copy each of the sql to a query analyzer and check for table scans. Is there a easier way ?

    -WK

  • July 21, 2006 at 9:08 am

    #650740

    Add the Performance>>Execution Plan event.  Then scan the trace file for table scans in the textual execution plan. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 21, 2006 at 9:40 am

    #650761

    Thank you. It worked like a charm.

    -WK

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

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