types of indexes with syntax sql code example

Example: what are all the different types of indexes in sql

"There are two types of Indexes in SQL Server

1.	Clustered Index

A clustered index defines the order in which data 
is physically stored in a table. Table data can 
be sorted in only way, therefore, there can be only 
one clustered index per table. In SQL Server, 
the primary key constraint automatically creates a 
clustered index on that particular column.

2.	Non-Clustered Index

A non-clustered index doesn’t sort the physical 
data inside the table. In fact, a non-clustered 
index is stored at one place and table data is 
stored in another place. This is similar to a 
textbook where the book content is located in o
ne place and the index is located in another. 
This allows for more than one non-clustered index per table."

Tags:

Sql Example