what is cluster and nin-cluster index?
Answers were Sorted based on User's Feedback
Answer / vikram
Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / rajkumar
There can be only 1 Clustered index in a table
where as nonclustered index can be upto 249
Clustered is physical sorted index..
non clustered is logical stored index is faster than
clustered index
thats all i know
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / manisha
cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.
a table can have max of 1 clustered index but can have upto
249 non clustered index.
Is This Answer Correct ? | 3 Yes | 0 No |
How connect excel to sql server?
What is Transparent Data Encryption?
Does union all remove duplicates?
What does the automatic recovery do?
How do I create a trace in sql server?
What stored by the master?
Can we call stored procedure in view in sql server?
How you can add messages to the nt event log from within a stored procedure?
What is the difference between varchar and nvarchar?
What is a periodical index?
What do you mean by tablesample?
Define master database?