What is Difference Between Clustered Index and Non-Clustered Index ?
Clustered Index :
- Clustered Index are used to arrange the data in sorted Order.
- There will be only one Clustered Index created on SQL Table.
- Clustered Index are faster than Non-Clustered Index
- It demand less memory during execution of SQL Query
Non-Clustered Index:
- Non-Clustered Index are used to collect the data at one place and records at another place OR you can refer it does not arrange the data in sorted Order
- There can be Multiple Non-Clustered Index on table.
- Non Clustered index are slower than Clustered Index.
- It demand more memory during execution of SQL query
