Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146899 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 analysis service repository?
What are out-of-range errors with date and time literals?
What is built-in/administrator?
What are audit control procedures?
What is the full form of dql?
what purpose does the model database serve? : Sql server database administration
How to create new tables with "create table" statements in ms sql server?
How to check table values in sql server?
What is subquery in sql?
What is the chart in report?
Explain insert into select statement?
What is lock escalation? : sql server database administration
Explain cross join or cartesian product in sql?
How to delete a database in ms sql server?
Can we hide the definition of a stored procedure from a use?
