Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
- 1 Answers
- 5336 Views
- United Healthcare, I also Faced
- E-Mail Answers
Answer Posted / anand vanam
•In clustered Index leaf node contains the actual data pages
where as in Non clustered index leaf node contains index
pages.
•You can have only one clustered index per table but you can
have 249 Non clustered indexes per table as per SQL 2005
(999 in SQL 2008)
•The row locator in clustered index is the Clustered Index
Key where as in Non clustered index row locator is a pointer
to the row.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Explain datetime2 data type in sal server 2008?
What is read committed?
How to convert character strings into numeric values?
How can you start sql server in different modes?
What are built in functions?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How data can be copied from one table to another table?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is difference between clustered and non clustered index?
Explain the properties of the relational tables?
How to execute the cursor queries with "open" statements?
What is the maximum rows in sql server table?
What is a primary index?
What is deploy, process and build? : sql server analysis services, ssas
What is the difference between truncate and delete commands?
