What is the basic difference between clustered and a
non-clustered index?
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
Explain the Ways to improve the performance of a sql azure database?
How you would rewrite the sql query to return the customerid sorted numerically?
Will count(column) include columns with null values in its count?
Explain the purpose of indexes?
Explain four layers of abstraction microsoft architectured?
How to make conditional sum in ssrs?
How much memory that we are using in Logshipping Concept?
Can multiple columns be used in sql group by clause in ms sql server?
How to add code to the existing article (using improve article)?
How we can refresh the view?
Explain an automatic checkpoint
What is sql language?
what are database files and filegroups? : Sql server database administration
How many replicas are maintained for each sql azure db?
How do indexes help, types?