O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reading Showplans

The showplan provides insight about how SQL Server is going to process a SQL statement. If you know what to look for in a showplan, the information it provides can be useful for tuning queries.

Those new to SQL Server should not be dismayed by the jargon used in the showplan. For example, the showplan uses words such as STREAM AGGREGATE. This is just a fancy way of saying that the query contains an aggregate function, such as AVG(), COUNT(), MAX(), MIN(), or SUM(). After you get past the lingo used by the showplan, you will find it a useful tool for optimizing queries.

Instead of looking at every possible output from the showplan, look for table scans in the showplan on tables that contain a large number of records. (Note: It ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required