Optimizing an Indexing Strategy by Using Microsoft® SQL Server„¢ 2005(4374)


In this 2-hour workshop you will learn how to apply various indexing strategies in order to enhance performance in your Microsoft® SQL Server™ 2005 Database solutions. Topics include index types, guidelines for designing indexes, and using clustered vs nonclustered indexes.

Within the workshop, you will analyze bottlenecks and apply indexes to various tables in order to improve performance. As a workshop, most of the learning will be done within the lab itself.

Having this experience will enable you to address performance issues that arise from poorly performing queries within your database solutions.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005.



  • Describe types of indexes
  • Describe index design guidelines
  • Describe guidelines for using Clustered and Nonclustered indexes


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-OIS-UMS
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend