Knowledge Base

Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in SQL Server 2000

Article ID: 815337

Article Last Modified on 2/27/2007

APPLIES TO

Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 7.0 Standard Edition

Session Summary

This Support WebCast will discuss how to read and understand the execution plans that SQL Server produces. This session will review the most common operators that are used when investigating query plans. This Support Web Cast will provide information about Microsoft SQL Server 7.0 and SQL Server 2000 execution plans. It will discuss how to read the execution plan steps involved in processing the query, including various operators and indexes that are used for each table; for example, nested loop, hash and merge joins, aggregates, and bookmarks. This Web Cast will provide an excellent opportunity to understand about execution plan.

This is a Level 200 session that was recorded March 27, 2003, and presented by Prabhaker Potharaju. Prabhaker Potharaju: Prabhaker Potharaju is currently a Technical Lead with Microsoft SQL Server Support team. He joined Microsoft as a SQL Server Support Professional in September 1998, when he started supporting SQL Server 6.5. His areas of expertise include SQL Server optimization and performance tuning.

Viewing the Presentation

To view, please click on the link: [javascript:fnViewMMC('http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/wc032703/manifest.xml'); View this Support Webcast] (Length: 1 hour 54 minutes)

'

This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.