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 |
What is meant by indexing files?
What functions can a view be used to performed?
What are the default system databases in sql server 2000?
what are batch in sql server?
How can you append an identity column to a temporary table?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Explain what is the purpose of sql profiler in sql server?
Is oracle faster than sql server?
what is the primary use of the model database? : Sql server administration
How can I check if a view exists in a sql server database?
What is ACID Property of Transaction?
What are built in functions?