Interested to Buy Any Domain ? << Click Here >> for more details...
Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
- 1 Answers
- 5684 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
Why are views required in the sql server or in any other database?
What is shrink log file?
How to execute a sql statement using mssql_query()?
What is 5nf in normalization form?
What are pages and extents? : SQL Server Architecture
Can I run multiple instances of sql server 2000 at the same time on one computer?
Explain a differential backup?
How many types of objects are there?
How to search for a string in all stored procedure in sql server?
What is database dimension? : sql server analysis services, ssas
What are statistics?
How do I uninstall sql server 2014?
How does Report Builder support Analysis Services cubes?
can any body tell me how to know the password of current user in sql server
What is a ddl statement?
