diffrence between Cluster Index and non Cluster Index
Answer Posted / indraneelandhavarapu
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 |
Post New Answer View All Answers
What is an entity-relationship diagram (erd)?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What guidelines should be followed to help minimize deadlocks?
Can we create clustered index on composite key?
How to include text values in sql statements?
What is filestream?
When a primary key constraint is included in a table, what other constraints does this imply?
What is correlated subquery in sql server?
what is the difference between a primary key and a unique key? : Sql server database administration
your distribution database is full what will u do
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is data set in report?
Write an sql query to find first weekday of the month?
Differentiate between ms sql server reporting services vs crystal reports?
what is the main function of a query parameter?