Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145959 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
What to perform pattern match with the like operator?
what's new in sql server 2016?
What does it mean to manipulate data?
Write a SQL command to insert and update only a particular field?
what happens on checkpoint? : Sql server database administration
Is ssrs support other database except ms sql server?
What is ddl command?
What are the disadvantages of indexes?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is attribute relationships, why we need it? : sql server analysis services, ssas
Difference between Sql server reporting services and Crystal reports?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How many categories of data types used by sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
What is collation sensitivity? Explain different types.
