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
Why primary key is required?
Does asenumerable execute the query?
What is a data manipulation language?
What are the two parts of design view?
What is use of trigger?
Why do we use cursors?
what tools available for managing mysql server? : Sql dba
What is the difference between jpql and sql?
What is trigger types in sql?
What is thread join () in threading?
What is varray in pl sql?
Why do we need sharding?
What are its different types of dbms?
What is pl sql script?
Is sql harder than python?