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
- 5775 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
How to specify the collation for a character data type in ms sql server?
What do you mean by data integrity?
Explain the stored procedure?
What are alternate keys?
How can you fetch alternate records from a table?
Why is sql server log file full?
What is failover clustering overview?
what is denormalization and when would you go for it? : Sql server database administration
How do you migrate data from mssql server to azure?
What are audit control procedures?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is a cursor, index in sql?
Does a full backup include transaction log?
What are cursors and when they are useful?
How to create percentile function?
