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

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
☆ 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 Question | Next Question |
Can you please explain the difference between foreign key and reference key? | Can you please explain the difference between EXE and a DLL? |