Difference between Cluster and Non-cluster index?
Answer Posted / vikram kumar
The biggest difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.
In SQL Server 2005 you'll probably hear the term "heap or B-
Tree."
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you edit the .rdl code associated with a linked report?
What is row-level compre?
What are the requirements for sql server 2016?
Disadvantages of the indexes?
How to convert a table data in XML format in sql server?
What are the types of indexes?
What is sparse columns of sql server 2008?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What is model database in sql server?
Do you know what is a trace frag? Where do we use it?
Where are sql server user names and passwords stored in sql server?
Where cross join is used?
What are the advantages of user defined function?
Why do you want to join software field as you have done your BE in Electronics?
What is set nocount on?