Post reply

Query Performance

  • August 17, 2005 at 11:54 pm

    #102713

    Hi ,

    if we have 2 queryies which gives same output , how to calaculate the which is the best throygh SHOW EXECUTION PLAN ,what shopuld the cost value .

    thankls

  • August 18, 2005 at 12:18 am

    #582920

    The cost value percentage will just highlight which part of the query takes the most time/resources. You really need to look at the number of reads (logical and physical) being done and the number of records going from each step in the plan.

    If possible, it would be a good idea to post each of the plans so we can compare them.

     

    --------------------
    Colt 45 - the original point and click interface

  • August 19, 2005 at 7:32 am

    #583511

    A more straight way is to capture the running duration for the two queries by running sql profiler. it can tell you logical reads and phsical writes etc as well.

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

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