Difference between Clustered index and non clustered index

Question

0

rajesh

Asked: February 26, 2019In: Computer Science

Difference between Clustered index and non clustered index

0

Difference between Clustered index and non clustered index

clustered vs non-clustered index performance | clustered vs non clustered index | difference between clustered and non-clustered index in sql server 2008 with example | when to use non clustered index | clustered and non clustered index in oracle | clustered index vs primary key | how to create clustered index in sql

clustered vs non-clustered index performance | clustered vs non clustered index | difference between clustered and non-clustered index in sql server 2008 with example | when to use non clustered index | clustered and non clustered index in oracle | clustered index vs primary key | how to create clustered index in sql clustered vs non-clustered index performance clustered vs non clustered index difference between clustered and non-clustered index in sql server 2008 with example when to use non clustered index clustered and non clustered index in oracle clustered index vs primary key how to create clustered index in sql

1 Answer

Leave an answer
Cancel reply

WebGuru · Answer 1 · May 31, 2020

WebGuru Professional

Added an answer on May 31, 2020 at 7:00 pm

CLUSTERED INDEX

1. Clustered indexes are stored physically on the table.
2. A table can have a single clustered index
3. Requires less memory space
4. Faster

NONCLUSTERED INDEX

1.Non-clustered indexes are stored separately
2. A table can have multiple nonclustered indexes
3. Requires more memory space
4. Slower

0

Reply
Share
Share

LEARN, SHARE KNOWLEDGE & WORK TOGETHER

Difference between Clustered index and non clustered index

1 Answer

Leave an answerCancel reply

Leave an answer
Cancel reply