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
- 5845 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
Can we delete data from a view?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain transaction server consistency?
What are differences in between sql server 2012 and sql server 2016?
How to convert numeric values to integers in ms sql server?
What are the advantages of passing name-value pairs as parameters?
How to find out the list schema name and table name for the database?
What is BCP? When does it used in sql server 2012?
How you can move data or databases between servers and databases in sql server?
How to create a local temporary stored procedure?
Explain the difference between cross join and full outer join?
What is order of B+tree?
What is unpivot?
How to use "begin ... End" statement structures in ms sql server?
What is store procedure? How do they work? When do you use?
