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

How to execute a sql statement using odbc_exec()?

574


Explain various data region available in ssrs with their use?

494


What is difference between getdate and sysdatetime in sql server 2008?

601


What do you mean by SQL injection attack?

622


What are the different types of sub-queries?

600






Do you know what is xpath?

559


What is the name of reporting services config file and what’s it’s used for?

107


How do I clean up sql server transaction log?

574


What are commit and rollback in sql?

569


SQL Server Architecture ?

1936


What are the two modes of authentication in sql server?

524


Write SQL queries on Self Join and Inner Join.

619


What are the dmvs? : sql server database administration

600


What is ms sql server reporting services?

510


What is clustered primary key?

554