Difference between Cluster and Non-cluster index?
- 32 Answers
- 141545 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
Why olap is used?
After removing a table from database, what other related objects have to be dropped explicitly?
What are the types of processing and explain each? : sql server analysis services, ssas
Define master database?
Do you know what is blocking?
What is sql server locking?
Are null values the same as that of zero or a blank space?
Describe in brief system database.
explain how to create a new schema in a database? : Sql server database administration
What is an indexed view?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How to turn off warning messages during php execution?
Write a SQL query to make a column as unique?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Indexes are updated automatically is the full-text index also updated automatically?
