What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
Answer Posted / 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 |
Post New Answer View All Answers
how to present a past time in hours, minutes and seconds? : Sql dba
What is implicit cursor in pl sql?
what is a constraint? : Sql dba
What are the methods of filing?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can we use loop in sql?
What type of join is sql join?
how to show all tables with 'mysql'? : Sql dba
What is cascade in sql?
What is rank dense_rank and partition in sql?
What is nosql example?
How many types of primary keys are there?
What is sql character function?
Why we use joins in sql?
How many columns should be in an index?