Sign Up Login


  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

How to list all login names on the ms sql server?

699

Explain about Views?

763

List the different index configurations possible for a table?

676

What is the default fill factor value?

761

What is the standby server?

682




How can we call UDF(User Define Function) using C# code in ASP.net ?

6363

What is difference between materialized view and view?

686

What stored by the master?

716

What is checkpoint process in the sql server?

708

What triggers long term care?

714

System variable and temporary variables

1900

How do I view a stored procedure in sql server?

727

How to create a user to access a database in ms sql server using "create user" statements?

724

How will you make an attribute not process? : sql server analysis services, ssas

753

What are pessimistic lock and optimistic lock?

735