Designing Indexes for Performance

Length: 2 Days
Prerequisites:  Basic knowledge of Microsoft SQL Server, Prior knowledge of SQL and T-SQL
Recommended: " Introduction to Microsoft SQL Server and Microsoft Systems Administration"


Overview

Soaring Eagle presents, "Designing Indexes for Performance." In this course you will learn index selection as it was taught to
Microsoft internal engineers from how the server selects indexes, to index storage structures, to how to quantify whether your
index is working better than another.

Key Benefits:  Learn how Microsoft SQL Server selects indexes. Besides learning how the optimizer works 
 you will also learn how to interpret SQL Server optimizer results. By the end of the course you will have a better understand of indexing internals.

Outline

• Introduction to Performance
• Query Analysis tools
• SQL Statement Processing
• Indexing
• Single Table Optimization
• Join Processing
• Subquery Processing
• Views
• Uinions
• Indexing & Cursors
• SQL - Specific Problems (optional)

 

Back to Course Listing