MS SQL Server - Query (part) Cost

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Query (part) Cost

Martijn Tonies

2005-05-31, 9:23 am

Hi,

I'm trying to figure out where the value of "Cost" comes from in the
Query Analyzer.

For example, when running this on Northwind:

select * from dbo.[Alphabetical list of products]

You get this 3 parts for the Query Plan. The part of
"Categories.PK_Categories" has a cost of 24% of the
total and a value of 0.0119... Where does this value
come from?

All I get is "cost for CPU" and "cost for I/O" - but adding
these together does not equal that value.

Anyone have a clue?

--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com

Sponsored Links