InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:15:42 GMT20http://www.sqlservercentral.com/Forums/Topic1422005-360-1.aspxThe 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.Wed, 20 Feb 2013 03:27:58 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic1422005-360-1.aspxHi 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.....Wed, 20 Feb 2013 03:18:17 GMTMinnu