What is clustered, non-clustured and unique index. How many indexes can be crea

What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?

Question Posted / wgk

3 Answers
11035 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?..

Answer / rajkumar

please don't give oracle answers in sqlserver

Is This Answer Correct ?

12 Yes

8 No

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?..

Answer / leena

clustered index physically store data orderly in a
table,but non-clustered index store data logically not
physically.
primary key is by default clustered index,and unique key is
by default non-clustered index.
A table can contain only one cluster index.

Is This Answer Correct ?

3 Yes

2 No

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?..

Answer / amit

A clustered index are those which created by user manually
and non clustered are automatically created by oracle server
when we create a primary key or a unique key on a column.

and as many as indexes can be created on table but it will
reduces the performance of the database.

Is This Answer Correct ?

1 Yes

10 No

Post New Answer