Can Somebody tell me the difference between Clustered & Non-
Clustered Index??

Answer Posted / ramesh.p

The difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where can you find the error log information? : sql server database administration

569


How to see existing views in ms sql server?

552


How to convert numeric expression data types by assignment operations?

523


what are the different types of SSRS reports?

112


Why are sql functions used?

622






How to make a column nullable?

605


Explain use of expression builder.

571


How to delete duplicate rows from table except one?

548


Does a sql server 2005 select statement require a from?

587


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

564


What is report server project?

106


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

644


What do you mean by a dependent functionality in a build?

661


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

560


What are the different types of cursor?

607