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
- 5836 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 what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to concatenate two binary strings together?
Why use stored procedures in sql server?
How do you run a trace?
What is the difference between the 2 operating modes of database mirroring?
What are temporal tables in sql server 2016?
What are the key configuration files for sql server reporting services ?
How to drop an existing table?
What is ddl and dml commands?
What is the full form of ddl?
How to invoke a trigger on demand?
Is sql server free?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What happens if null values are involved in string operations?
What is the maximum size of sql server database?
