Index means to sort the data. Cluster index is physical order of the dat

diffrence between Cluster Index and non Cluster Index

Question Posted / kumar.t

Answer Posted / kumar.t

Index means to sort the data.

Cluster index is physical order of the data.

Non Cluster index is logical order of the data.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain unique key in sql server?

722

What are a database and a data warehouse?

739

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

715

What command would you use to add a column to a table in sql server?

978

Mention a few common trace flags used with sql server?

679

Which autogrowth database setting is good?

790

explain how to create a new schema in a database? : Sql server database administration

782

Is a primary key unique?

704

How to create a local temporary stored procedure?

686

How many types of functions are there in sql server?

609

How to run sql server 2005 books online on your local system?

713

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1764

How you can move data or databases between servers and databases in sql server?

764

How to create a dynamic cursor with the dynamic option?

720

What is a non equi join?

733