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

How much does sql server 2016 cost?

530


Explain the steps to create and execute a user-defined function in the sql server?

530


What the different topologies in which replication can be configured?

556


Give the query of getting last two records from the table in SQL SERVER?

541


How many columns can exist together per table?

703






explain different types of constraints? : Sql server database administration

515


What is create command?

524


If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

668


How do you rename a table in sql server?

490


How to fetch the next row from a cursor with a "fetch" statement?

589


How to see the event list of an existing trigger using sys.trigger_events?

569


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

533


How would we use distinct statement? What is its use?

603


What is de-normalization and what are some of the examples of it?

531


How do I open a .db file?

482