Post reply

Query Cost

  • February 20, 2013 at 3:18 am

    #270644

    Hi Team,

    As per my knowledge "Query Cost is a measure of the CPU and input-output resources used by the query"

    but when am using a small query "select * from student where stud_id=1050"

    in "Execution plan" window query cost is showing as 100%,

    Reason please.....

  • February 20, 2013 at 3:27 am

    #1589494

    The percentage you are seeing is the percentage relative to the batch.

    Since there is only one query in batch it shows 100 percent.

    If you had more than one statement for a eg if it was a stored proc, you would see this spread across the queries.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

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

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

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