Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147090 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
How can you find out how many rows returned in a cursor?
What is user defined stored procedures?
Do you know what is rank function?
What is the purpose of object explorer and its features? : sql server management studio
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Explain alternate key, candidate key and composite key in sql server?
Explain what are magic tables in sql server?
How to create new tables with "select ... Into" statements in ms sql server?
What are scalar functions in sql?
What is user defined datatypes and when you should go for them?
What is trigger in salesforce?
what method you can use to reduce the overhead of Reporting Services data sources?
Explain aggregate functions?
How you can get a list of all the table constraints in a database?
What is ddl command?
