The Implement Appropriate Indexing Strategy on Fact Tables module provides you with the instructions and devices to develop hands on skills in the following topics:

  • Implementing clustered index on fact tables
  • Implementing non-clustered index on fact tables

Exercise 1 - Implementing Clustered Index on Fact Table

You can use indexes in tables to speed up the performance of queries. Indexing organizes database data pages into a hierarchical structure. Clustered index is a type of index that reorganizes the way records in the table are physically stored. A table can have only one clustered index. When a primary key is created on a table, a clustered index is created on the table by default.

In this exercise, you will learn how to create clustered index on fact tables using SQL Server Management Studio.

Exercise 2 - Implementing Non-Clustered Index

A non-clustered index is a special type of index that does not alter the physical order of the rows stored in a table. The leaf node of a non-clustered index contains a pointer to the table data. You generally create non-clustered index to improve the performance of frequently executed queries that are not covered by the clustered index.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.