Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148057 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 do you understand by sql server agent?
what is the sql equivaent of the dataset relation object ?
What is ms sql server service broker?
How many categories of data types used by sql server?
How to access the inserted record of an event?
How to test subquery results with the exists operator?
Relational calculus is what type of language?
How to apply cascading referential integrity in place of triggers?
What are the advantages of stored procedure in sql server?
What are different types of raid levels?
What is difference between primary key and foreign key?
What are the aggregate and scalar functions?
Mention the differences between local and global temporary tables.
Explain how dts is used to extract, transform and consolidate data?
What is an active database?
