Altruist Technologies Advisor Interview Questions and Answers

Clustered index physically reorders the data in the table while non-clustered index creates a separate structure.

• Clustered index determines the physical order of data in the table, while non-clustered index does not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered index is faster for retrieval of data, while non-clustered index is faster for retrieval of specific rows.

• Example: Clu...read more