Answers

Question and Answer:

  Home  Infosys

⟩ Can you please explain the difference between Clustered index and non clustered index?

★ Clustered Index:

☆ Only one per table

☆ Faster to read than non clustered as data is physically stored in index order

★ Non Clustered Index:

☆ Can be used many times per table

☆ Quicker for insert and update operations than a clustered index

 202 views

More Questions for you: