Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147077 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
List down some advantages of sql stored procedure?
What is unique key constraint?
What is dbcc? Give few examples.
What is cursor in ms sql server?
What are security principals used in sql server 2005?
Can we write trigger for view?
Do you know the different ddl commands in sql?
What is always encrypted?
What is difference between joins and subqueries?
what is the sql equivaent of the dataset relation object ?
when you create a database how is it stored? : Sql server database administration
What do you mean by sql server agent?
Explain about nested stored procedure?
What is the default value of an integer data type in sql server 2005?
What is the difference between seek predicate and predicate?
