Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147052 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / yashpal
Clustered index will be created by default when u
create primary key on a column. only one clustered index is
created per table
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is 1nf normalization form?
What is database black box testing?
What happens if null values are involved in boolean operations?
Can you explain what is indexed view? How to create it?
How to verify a user name with sqlcmd tool?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the federation in sql azure?
How to get a list all databases on the sql server?
List the different types of joins?
How to get the query of a table in sql server?
What is the index requirement in SQL Azure?
what stored procedure can you use to display the current processes? : Sql server administration
What is a primary key?
What is the difference between composite index and covering index?
Can we use where clause in union?
