Collection and sharing of, interview questions and answers asked in various interviews, faqs and articles.....
SQL Server : What are the difference between clustered and a non-clustered index?
A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.
No comments:
Post a Comment