Support WebCast: Effective Indexing and Statistics with SQL 2000

Session Summary

This session will explain the different types of indexing mechanisms in SQL Server 2000. It will cover how to choose an effective index for a query, and it will discuss indexing techniques like covering indexes, index intersection, and index join. It will explain the role of statistics in using indexes effectively, as well as using the Index Tuning Wizard for maintaining proper indexes on the database

This is a Level 200 (http://support.microsoft.com/default.aspx?scid=gp;en-us;webcastlevels&sd=gn) session that was recorded July 6, 2001 and presented by Sajal Dam. Sajal Dam is an Application Development Consultant and has been working at Microsoft for three years. He works with various Microsoft Premier customers to help tune their Web and WinDNA applications for performance and scalability, and he conducts SQL Server performance tuning workshops. His strengths include optimizing the performance of front-end Web server to back-end SQL Server.

Viewing the Presentation

To view, please click on the link: View this Support Webcast (Length: 1 hour 42 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/e/b/6/eb6dac6b-cf5e-4f6b-aa13-03a4f022150d/wc070601.exe) wc070601. This is a SIZE-KB Microsoft PowerPoint (.ppt) file.
If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (http://office.microsoft.com/downloads/2000/Ppview97.aspx) (1,911 KB).

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

Tell a friend about this Support WebCast (mailto:?subject=Support WebCast: Effective Indexing and Statistics with SQL 2000&body=Take a look at this Microsoft Support WebCast about Effective Indexing and Statistics with SQL 2000 (##MONTHDAY##, 2003). More information about this WebCast is available at http://support.microsoft.com/WebCasts.)

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

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