Difference b/w Clustered & non-clustered index? Not the
bookish definition, but how they internally works in SQL Server?
- 1 Answers
- 5334 Views
- United Healthcare, I also Faced
- E-Mail Answers
Answer / 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 |
What are the properties of sub-query?
What is normalization of database? What are its benefits?
Why is sql server log file full?
What are subquery and its properties?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What are different types of raid levels?
Can a table have 2 primary keys?
What is difference between index seek vs. Index scan?
how to retrive only second row from table in sql server 2000?
What do you understand by the data quality services in sql server?
How many index keys possible for a table
How can sql injection be stopped? : sql server security
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
