S.No |
Clustered
Indexes |
Non-Clustered
Indexes |
1 |
Clustered Index reorders the physical storage of records in the able | It
sorts and maintain a separate storage |
2 |
There
can be only one Clustered index per table |
We can have 249(before 2008) ,999 (from 2008) non-clustered indexes in a table |
3 |
The
leaf nodes contain data |
The
leaf node contains pointer to data |
4 |
To
create clustered index SQLServer required more memory because the leaf pages in the tree structure
will maintain actual data . |
To
create non-clustered index Sql server requires less memory because the leaf pages will contain pointers
to actual data. |
5 |
By using clustered index retrieving data is more faster,when we compare with non-clustered index. | By
using non-clustered index retrieving data is slower than clustered index. |
Labels
- Differences (38)
- MongoDB (13)
- MySQL (10)
- Oracle (6)
- ORACLE DBA (1)
- Performance Tuning (13)
- PTuning (3)
- Scenarios (4)
- Scripts (35)
- SQLDBA (99)
- SQLDeveloper (66)
- SSIS (5)
- SSRS (8)
- Troubleshooting (37)
Monday, 21 December 2015
SQL Server - Differences between Clustered Indexes and Non-Clustered Indexes?
Labels:
Differences,
SQLDeveloper
Subscribe to:
Post Comments (Atom)
Great differences.
ReplyDelete