Infosys Question:

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

Infosys Interview Question
Infosys Interview Question

Answer:

★ 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


Previous QuestionNext Question
Can you please explain the difference between foreign key and reference key?Can you please explain the difference between EXE and a DLL?