Difference between Cluster and Non-cluster index?
- 32 Answers
- 141457 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / chandu
Clustered index:
A Table have only one clustered index.
Once we defined a column with primary key constraint, sql
server automatically creates unique clustered index on that
column,
Actual rows arranged in same order as index.
Eg: Dictionary.
Non-clustered index:
Atable have 249 non clustered index.
Once we defined a column with unique key constrain , sql
server automatically create non clustered index.
Actual rows not arranged in same order as index.
Eg: Text book
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How global temporary tables are represented and its scope?
What is explicit cursors?
Explain what are various ways to enhance the ssrs report?
How can you find out how many rows returned in a cursor?
What is the recursive stored procedure in sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
What are the different types of indexes?
Which is the latest version of sql server and when it is released?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How to update values in a table with update statements in ms sql server?
What are types of storage modes? : sql server analysis services, ssas
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is multi-statement table-value user-defined function?
