diffrence between Cluster Index and non Cluster Index
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 |
Post New Answer View All Answers
How to retrieve field values using mssql_result()?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is the temp table?
Can binary strings be converted into numeric or float data types?
Why use sub query in sql server and list out types of sub queries?
What is the difference between grant and with grant while giving permissions to the user?
Why do we need normalization?
How do I create a stored procedure in sql server?
What is an identity column in insert statements?
Define msdb database?
Explain indexed views and partitioned view with their syntax.
Can you explain various data region available in ssrs with their use?
What is the difference between a "where" clause and a "having" clause?
What are the different types of backups avaialabe in sql server 2005?
How to drop an existing schema in ms sql server?