Difference between Cluster and Non-cluster index?
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
What are the differences between decimal and float in ms sql server?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
How can you tell if a database object is invalid?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Is port 1433 secure?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How do I create a stored procedure in sql server?
What is the difference between mysql and mysqli?
What is inline variable assignment?
When is the use of update_statistics command?
What is query parameter in ssrs?
What is etl - extraction, transformation, and loading?
How to generate create table script on an existing table in ms sql server?
What is meant by referential integrity?
What is the security principal at the server level that represents your session?