Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147133 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / prakash
Cluster index :-
1) CLUSTERED INDEX IS PHYSICALLY STORED THE DATA.
2)ONE TABLE CAN HAVE ONLY ONE CLUSTERED INDEX
BECAUSE IT STORED IN ORDER OF THE CLUSTERED KEY.
3)CREATING A CLUSTERED INDEX ON A TABLE RE-ARRANGES
THE DATA IN A SEQUENTIAL MANNER
4)ONCE WE DEFINED A COLUMN WITH PRIMARY KEY CONSTRAINT, SQL
SERVER AUTOMATICALLY CREATES UNIQUE CLUSTERED INDEX ON THAT
COLUMN
5) THE LEAF LEVEL OF A CLUSTERED INDEX IS THE ACTUAL
DATA
__________________________________________________________
NON-CLUSTERED INDEX:-
1)NON- CLUSTERED INDEX IS LOGICALLY STORED DATA.
2) ONE TABLE CAN HAVE 249 NON- CLUTTERED INDEX IN SERVER-2005
AND 999 IN SERVER-2008
3)NON-CLUSTERED INDEX IS CREATED ON A TABLE, THE DATA IS NOT
PHYSICALLY
RE-ARRANGED IN SEQUENTIAL ORDER.
4)ONCE WE DEFINED A COLUMN WITH UNIQUE KEY CONSTRAIN , SQL
SERVER AUTOMATICALLY CREATE NON CLUSTERED INDEX.
5) NON-CLUSTERED INDEX THE LEAF LEVEL IS
ACTUALLY A POINTER TO THE DATA IN ROWS
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how you can deploy an ssrs report?
How to get the definition of a stored procedure back?
What is SQL Server?
What are the different types of replication are there in sql server 2000?
What is 1nf 2nf?
What is store procedure? How do they work? When do you use?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are different types of roles provided by ssrs?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
what are the types of indexes? : Sql server database administration
What are page splits?
What are logical database components? : SQL Server Architecture
Can you use order by when defining a view?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Explain acid?
