diffrence between Cluster Index and non Cluster Index
Answers were Sorted based on User's Feedback
Answer / naren
Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kumar.t
Index means to sort the data.
Cluster index is physical order of the data.
Non Cluster index is logical order of the data.
Is This Answer Correct ? | 2 Yes | 0 No |
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.
Is This Answer Correct ? | 2 Yes | 0 No |
What is dknf in normalization form?
Can we use Truncate command on a table which is referenced by FOREIGN KEY?
Explain system views?
what is a traditional network library for sql servers? : Sql server database administration
Which data type columns are the best candidates for full-text indexing?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What are three SQL keywords used to change or set someone?s permissions?
What is collation?
What is the purpose of sql profiler in sql server? : sql server database administration
What is 1nf 2nf and 3nf?
What is the appropriate number of test cases that you can write on a database?
How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?