Query Cost

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Query Cost

Query Cost

Rate Topic

Display Mode

Topic Options

Author

Message

Minnu

Posted Wednesday, February 20, 2013 3:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 119, Visits: 361

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.....

Post #1422005

joeroshan

Posted Wednesday, February 20, 2013 3:27 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:12 AM
Points: 573, Visits: 1,165

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
Custom cleanup script for backups

Post #1422011

« Prev Topic | Next Topic »

Permissions