sql server(2K) in depth - costs and query plans

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

sql server(2K) in depth - costs and query plans

Author

Topic

BitShift
Yak Posting Veteran

98 Posts

Posted - 2006-10-01 : 17:31:13

Can anyone provide a url that explains query plans and associated details of the features behind the "cost" button within sql enterprise manager and explain query plans ?

Kristen
Test

22859 Posts

Posted - 2006-10-02 : 06:45:08

Slightly tangential answer to your question:

I do this:


-- Comment in the SHOWPLAN to see the Query Plan, OR the STATISTICS to see the logical stats
-- SET SHOWPLAN_TEXT ON
GO
-- SET STATISTICS IO ON; SET STATISTICS TIME ON

-- ... put query here - e.g.:

SELECT * FROM Northwind.dbo.Products

SET STATISTICS IO OFF; SET STATISTICS TIME OFF
GO
SET SET SHOWPLAN_TEXT OFF
GO

and using the STATISTICS stuff I work on getting the reported SCAN COUNT and LOGICAL READS as low as possible - ignoring the other figures, in the main.

I tend to only use the SHOWPLAN to see what index, if any, is being used.

Its probably a gross oversimplification, but it might get you problem solving on an 80:20 basis - but if you need to know the Nuts and Bolts for an MS Exam you'll need to read up more than this, of course.

More details on what the various things here mean: http://www.sql-server-performance.com/statistics_io_time.asp

Kristen

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-10-02 : 08:48:44

Here are a few links you could try:

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

Actually, googleing will get you a long way on this one:
http://www.google.com/search?hl=en&q=sql+server+execution+plan&meta=

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources