Post reply

Query Optimization

  • March 24, 2005 at 6:05 am

    #166518

    Hi

      How can I compare the Query results before optimization and after optimization. Is there any way I can save the query excution plan output in a table or is there any system table where I can find those results?

     

    Thanks

    Khalid

  • March 24, 2005 at 6:43 am

    #548723

    In QA use

    SET SHOWPLAN_TEXT ON

    To generate a text version of the execution plan, which you can then save to a file to compare afterwards.

  • March 25, 2005 at 7:22 am

    #548941

    Hi

            Thanks for response but this method is not showing all the details that I get from show query plan in Query Analyzer. I am not getting I/O Cost and CPU Cost.

     

    Thanks

    Khalid

  • March 25, 2005 at 10:46 am

    #548981

    Check out BOL under SET, there are a few more options you might want to SET 'ON'. 'STATISTICS IO' & 'STATISTICS TIME' might start to shed the light that you need.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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