1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the basic difference between clustered and a
non-clustered index?

Question Posted / santosh kumar

Answer Posted / santosh kumar

Index is Used for fast access the data.
Cluster Index is Unique in a table.One Table Contains Only
one Cluster Index but 249 Non Cluster Index is
Possible.Cluster Index is a Physical Storage and Non cluster
Index is a logical storage of the data.

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of dml?

552

What are different type of Collation Sensitivity?

552

what types of replication are supported in sql server? : Sql server database administration

458

What is self contained multi valued query?

552

What do you understand by the data quality services in sql server?

493




what is a deadlock? : Sql server database administration

493

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

561

explain different types of cursors? : Sql server database administration

559

How to create view in stored procedure sql server?

501

What are number line correlation administrators will use while working with a subquery?

622

What happens if null values are involved in arithmetic operations?

582

ow to bring suspect mode datbase online from scratch

1399

What new data source types were added in ssrs 2014?

107

How to create an identity column?

634

What is SQL Azure Data sync?

103