Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146024 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ankit murela
cluster index:- (1)only one cluster index can be created.
(2)sort the data physically.
(3)Applied on columns which are not modifier frequencely.
(4)the leaf nodes of a cluster index contain the data pages
non-cluster index:- (1)there can 249 non cluster index per table.
(2)does not sort the data physically.
(3)Applied on columns which are modifier frequencely.
(4)The leaf nodes of a non cluster index does not contain the data pages
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Explain the difference between clustered and non-clustered index?
Can we use pragma autonomous_transaction in trigger?
How to drop an existing table with "drop table" statements in ms sql server?
Explain the ways to controlling cursor behavior?
Why is replication required on the sql server?
Why use identity in sql server?
How many types of keys are there?
What information is maintained within the msdb database?
What is ssrs?
what is denormalization? : Sql server database administration
How to use subqueries in the from clause in ms sql server?
Can we use max in where clause?
What are the different types of upgrades that can be performed in sql server?
Give an example of why you would want to denormalize a database
