Microsoft KB Archive/815337

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

Additional Resources
Download presentation This is a 178-KB Microsoft PowerPoint (.ppt) file.

If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (2,752 KB).

Read the transcript from this Support WebCast

[mailto:?subject=Support%20WebCast:%20Microsoft%20SQL%20Server%202000:%20Reading%20Execution%20Plans%20in%20SQL%20Server%202000&body=Take%20a%20look%20at%20this%20Microsoft%20Support%20WebCast%20about%20Microsoft%20SQL%20Server%202000:%20Reading%20Execution%20Plans%20in%20SQL%20Server%202000%20(032703,%202003).%20More%20information%20about%20this%20WebCast%20is%20available%20at%20http://support.microsoft.com/WebCasts. Tell a friend about this Support WebCast]

Supplemental reading:
 * SQL Server Books Online - Topic: Analyzing Queries

Provide Feedback on this Broadcast

Support WebCasts Home

Additional query words: plan reading

Keywords: kbdownload kbtshoot kbtshoot kbwebcastsupport KB815337

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.