Difference between Cluster and Non-cluster index?
- 32 Answers
- 138526 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ghanshyam vishwakarma
CLUSTER:- cluster like a pointer that point to one page to
another and get the final data.
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the 7 disadvantages to a manual system?
Explain about unique identifier data type in sql server?
What are the differences between char and nchar in ms sql server?
What is built-in/administrator?
What are the advantages of using stored procedures?
What are the difference between primary key and unique key? : sql server database administration
Explain indexing and what are the advantages of it?
What are the components of dbms?
What is the default schema of your login session in ms sql server?
What is snapshot replication?
What is a view in sql?
What are the different acid properties?
What are the grouping functions?
Differentiate between a local and a global temporary table?
Do you know what is similarity and difference between truncate and delete in sql?
