Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147076 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
Tell me about pre-defined functions of sql?
what is the system function to get the current user's user id? : Sql server database administration
What is reportserver and reportservertempdb ?
Does a sql server 2005 select statement require a from?
is there a column to which a default can't be bound? : Sql server database administration
What is fill factor and pad index?
What is table valued function and scalar valued functions?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How many ways to create table-valued functions?
Explain what is meant by replication of database?
What is change tracking in sql server?
Can two different columns be merged into single column? Show practically?
What are the characteristics of modern DBMS?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain activity monitors
