Explain the difference between clustered and non-clustered index?
Submitted by: AdministratorBoth stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data. We can have only one clustered index in a table but we can have many non-clustered index in a table. Physical data in the table is sorted in the order of clustered index while not with the case of non-clustered data.
Submitted by: Administrator
Submitted by: Administrator
Read Online MS SQL Server Indexes Job Interview Questions And Answers
Top MS SQL Server Indexes Questions
| ☺ | Explain the types of indexes? |
| ☺ | Explain the purpose of indexes? |
| ☺ | Can you explain important index characteristics? |
| ☺ | Write down the syntax and an example for create, rename and delete index? |
| ☺ | Explain Having clause and Where clause? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
