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
Explain various data region available in ssrs with their use?
What is collation sensitivity? Explain different types.
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is wide table?
How to set database to be read_only in ms sql server?
How to declare a cursor with "declare ... Cursor" in ms sql server?
what are the different types of SSRS reports?
What are the different types of replication are there in sql server 2000?
How does a profiler work?
What is sql server english query?
Is truncate a dml command?
How can you list all the columns in a database?
What is dbcc?
How can I check if a view exists in a sql server database?
What is delete query?