Clustered index is used to sort the data physically. Where as non clustered index will have a reference to the data stored.
Clustered index is too fast where as non clustered index is comparatively slower.
Clustered index will hold huge memory for creation and for working when compared to non clustered index.
Only one clustered index can be created for a table where as 249 non clustered index can be created.
Regards,
Venkatesan Prabu. J
No comments:
Post a Comment