Clustered and Non-Clustered Index

Clustered and Non-Clustered Index in SQL

Welcome to next detailed tutorial on Index

Let's learn about it.

Topics which will be covered are as below:

1. Introduction

2. Know : What is an Index

3. Know : Types of Index

4. Clustered Index

a)  How To - Create a clustered index by using Object Explorer

b)  How To - Create a clustered index by using the Table Designer

c)  How To - Create a clustered index using Query

5. Non-Clustered Index

a)  How To - Create a non-clustered index by using the Table Designer

b)  How To - Create a non-clustered index by using Object Explorer

c)  How To - Create a non-clustered index on a table

6. Benefits and Side Effects of Index

7. Quick Diff between Clustered indexes & non-clustered indexes