February 20, 2013 at 3:18 am
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
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply