What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
- 3 Answers
- 11038 Views
- TCS, I also Faced
- E-Mail Answers
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
What are some predefined exceptions in pl/sql?
How do you remove duplicate records from a table?
How do you explain an index number?
What is foreign key sql?
what is rollback? : Sql dba
What is the main difference between sql and pl/sql?
What is a design view?
How do I find duplicates in sql?
What sql database should I use?
Differentiate between pl/sql and sql?
Can cursors be part of a trigger body?
What is Difference Between Unique and Primary Key Constraints?
What is informix sql?
How do I start sql from command line?
What are the limitations of sql express?
