What is the basic difference between clustered and a
non-clustered index?
Answer Posted / guest
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 ? | 89 Yes | 9 No |
Post New Answer View All Answers
How do we know if any query is retrieving a large amount of data or very little data?
Does partitioning improve performance?
What is a join in sql?
What are “lock” hints?
Tell me what is the difference between locking and multi-versioning?
what is raid? : Sql server database administration
Explain the different types of backups available in sql server? : sql server database administration
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Explain what role entity and relationship play in an ER diagram.
Explain about SQLOS?
Explain contrast amongst grouped and non-bunched records?
What is meant by datasource?
Tell me what is fill factor?
Write a sql query to display the current date?