diffrence between Cluster Index and non Cluster Index

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain multiserver query

714


What is an sql server agent?

729


Why the trigger fires multiple times in single login?

882


What is the stuff?

711


Can an entity have two primary keys?

725






How do I edit a stored procedure in sql server?

682


What are 3 ways to get a count of the number of records in a table?

827


What is difference between index and primary key?

797


What is the current limitation of the size of SQL Azure DB?

120


Is null vs coalesce?

644


How to add a new dsn with the odbc driver for sql server?

737


How to find the source of a table in sql server?

710


How to receive output values from stored procedures?

705


Explain log shipping and mention its advantages.

783


What are the different types of subquery?

819