what is the difference between Non-Clustered Index and Index. I am tired of finding any huge difference between them.
So can you guys please help me out in this.
· Index
I guess you meant Non-clustered Index and Clustered Index. Is that right?
Since you have mentioned any huge difference between them, I am not sure what have you found and understood about them till now.
The first and most basic and notable difference between them is the Leaf level Page of a Clustered Index is the data itself where as the leaf level page of a clustered index contains the pointer to the data.
There are few other differences, but not sure what are those that you are already know.
In other words, when you create a clustered index, the table itself is sorted in the specified order. When you create a non clustered index, a new index table is created that contains the index key and points back to each row in the table.
Managed Windows Shared Hosting by OrcsWeb