Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146123 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar gupta
CLUSTERED INDEX:
Clustered index will be created by default when u
create primary key on a column. So we can create one
clustered index per table. clustered index is stored in
serial passion.
NON CLUSTERED INDEX:
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 ? | 141 Yes | 37 No |
Post New Answer View All Answers
When to use null data driven subscription?
How do indexes help, types?
What is 4nf in normalization form?
when you create a database how is it stored? : Sql server database administration
What does null mean?
Write down the syntax and an example for create, rename and delete index?
Where cross join is used?
How to provide values to user defined function parameters?
How do I make a resultset scrollable?
What is create statement?
What is row_number function?
Explain acid?
What is an indexing strategy?
Write a query for primary key constraint with identity key word?
How to convert a unicode strings to non-unicode strings?
