Thursday , October 18 2018
Home / DataBase / SQL SERVER / Indexes in Sql Server one by one

Indexes in Sql Server one by one

Indexes in Sql Server one by one:-

Indexes:
Indexes are created to Improve performance of data accessing or data retrieval
Index Improves performance of “select” operation.
Types of Indexes:
1.simple Index
2.composite Index
3.Unique Index
4.Clustered Index
5.Non Clustered Index

Sample Tables:

Table 1:EMPLOYEE

1.Simple Index:-
If the Index is created on single column then the Index is called simple Index

2.composite Index:-

If index is based on Multiple Columns then if is called composite Index.

3.Unique Index:-

Unique Index doesn’t allow duplicates into the column on which index is created

 

4.Clustered Index:-
Order of values in index and order of values in table are same then the Index is called Clustered Index.
–>By Default SQL Server creates Clustered index on primarykey columns
–>A Table Allows only 1 Clustered Index
–>A Table Allows 255 non Clustered Indexes

5.Non Clustered Index:-

If order of the values in index and Order of the values in table are not same then the index is called Non Clustered Index.

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …