Difference between Cluster and Non-cluster index?
- 32 Answers
- 141874 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
Can You Use Data Mining Models In Ssrs?
Can you use order by when defining a view?
How can you insert null values in a column while inserting the data?
What do you understand by the denormalisation?
What is the difference between dropping a database and taking a database offline?
Define clusters?
What are page splits? : SQL Server Architecture
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Which sql server table is used to hold the stored procedure script?
How to retrieve error messages using odbc_errormsg()?
How to run sql server 2005 books online on your local system?
What is @@error in sql?
What is the significance of master, tempdb and model databases?
Mention the differences between having and where clause.
How to optimize stored procedures in sql server?
