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
define sql insert statement ? : Sql dba
What is sqlerrd?
How to rename a table?
What is the difference between the sql*loader and import utilities? : aql loader
What is a scalar value in sql?
Is a secondary key the same as a foreign key?
What is sqlca in db2?
What is normalization in a database?
What is an inner join sql?
What is triggering circuit?
Why do we go for stored procedures?
Does oracle roll back the transaction on an error?
Write a unique difference between a function and a stored procedure.
how many ways we can we find the current date using mysql? : Sql dba
What is rtm in testing?