Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148199 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / naren
clustered index is created on actual data.
Non clustered index ix created on pointer of data.
If there is primary key by default clustered index is
created.
else non clustered index created.
only one clustered index is possible to create.
249 non clustered indexex can be created.
| Is This Answer Correct ? | 59 Yes | 15 No |
Post New Answer View All Answers
What is transaction server isolation?
Why do we need normalization?
What is relationship? What number of sorts of relationship are there?
What is a cube? : sql server analysis services, ssas
What are the restrictions applicable while creating views? : SQL Server Architecture
What is a data source file?
Explain try...catch with sql server?
How to find out what is the default collation in a database?
Does the order of columns in update statements matter?
What are the types of lock supported by ?
What is a periodical index?
What is abstracting periodical?
List out different types of normalizations in sql server and explain each of them?
Explain data warehousing in sql server?
What is reportserver and reportservertempdb ?
