Difference between Cluster and Non-cluster index?

Answer Posted / helps

The index one sees in the beginning of a book is a
clustered index and the index one sees at the end of the
book is a non clustered index.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the openxml statement in sql server?

536


What is the command dbcc checkdb used for?

530


How to count groups returned with the group by clause in ms sql server?

556


how can u get last observation in an unknown dataset ?

1999


How to list all dsn entries on your local machine using odbc_data_source()?

555






How to create nested stored procedure?

541


What new changes are being made in SQL Server?

574


What is the dbcc command and why is it used?

569


What the different components of Replication and what is their use?

559


What is the parse query button used for?

602


You want to implement the many-to-many relationship while designing tables. How would you do it?

559


What are the limitations/drawbacks or ssrs 2008 r2?

86


What is shared lock?

487


What is the difference between mysql and sql server?

467


Mention the 3 ways to get a count of the number of records in a table.

553