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 BCP? When does it used in sql server 2012?

750


How to execute a sql statement using mssql_query()?

712


What are recommended options to be used while using db mirroring? : sql server database administration

759


How to insert new line characters into strings?

719


What is rtm version in sql server?

694






What is an execution plan? How would you view the execution plan?

805


How to rebuild the master database?

748


What is coalesce and check constraint in sql server?

715


Explain about analysis services?

756


What do you understand by user-defined function in the sql server?

696


What is the meaning of resultset type_scroll_insensitive?

728


What are different types of roles provided by ssrs?

128


How many replicas are maintained for each sql azure db?

118


how you can get the list of largest tables in a database? : Sql server administration

723


How to drop existing indexes in ms sql server?

754