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

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 (http://support.microsoft.com/default.aspx?scid=gp;en-us;webcastlevels&sd=gn) 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: 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 (http://download.microsoft.com/download/7/b/1/7b11ead0-3446-438c-b85e-ec7e488ccbc6/wc032703.exe) 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 (http://www.microsoft.com/downloads/details.aspx?FamilyId=428D5727-43AB-4F24-90B7-A94784AF71A4&displaylang=en) (1,911 KB).

Read the transcript from this Support WebCast (http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2fwebcasts%2fen%2ftranscripts%2fwct032703.asp)

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

Supplemental reading:

• SQL Server Books Online - Topic: Analyzing Queries

Provide Feedback on this Broadcast (http://support.microsoft.com/common/survey.aspx?scid=sw;en;1073&p0=wc&p1=en-us&p2=WC032703)

Support WebCasts Home (http://support.microsoft.com/webcasts)