What is the basic difference between clustered and a
non-clustered index?
Answer Posted / s.purushothaman
The 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.
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is the difference between local and global temporary tables?
What are the filtered indexes?
How does the report manager work in SSRS?
What is the use of toad or sqldbx.?
What is right outer join in sql server joins?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Does partitioning improve performance sql server?
How to use “drop” keyword in sql server and give an example?
Explain what are the restrictions while creating batches in sql server?
What do you mean by acid?
How to find the service pack installed? : sql server database administration
How to connect ms access to sql servers through odbc?
What is difference between clustered index and non clustered index?
User wants only to display only pdf as export option in report manager. How to achieve this?
Can two tables share a primary key?