Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148114 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 please differentiate between a primary key and a unique key?
Can you explain powershell included in sql server 2008?
what are the three command line utilities and what are their primary functions?
Tell me what is sql profiler?
What is an identity column in insert statements?
How to update multiple rows with one update statement in ms sql server?
What is use of @@ spid in sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is the difference between a "where" clause and a "having" clause?
Do you know how to store and query spatial data?
Can a table have 2 primary keys?
What do you mean by authentication modes in sql server?
What is the cartesian product of table?
What is transaction server explicit transaction?
How to insert new line characters into strings?
