Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
- 3 Answers
- 11598 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 is a natural join?
What is before trigger?
what are ddl statements in mysql? : Sql dba
What is pivot table in sql?
Can you upgrade sql express to full sql?
what are the disadvantages of mysql? : Sql dba
How do you explain an index number?
What is procedure and function in sql?
Explain the methods used to protect source code of pl/sql.
How to change sql*plus system settings?
How do you remove duplicates without using distinct in sql?
Can function return multiple values in sql?
Can we rollback delete command?
What are the topics in pl sql?
what are the performance and scalability characteristics of mysql? : Sql dba
