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
- 5838 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 |
Which is better statement or preparedstatement?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is difference between inner join and join?
Explain subquery and state its properties?
Explain what you mean by 3 tier architecture.
Explain the dbcc pintable command when would you use it?
What is acid mean in sql server?
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What do you do in data exploration
What are the different types of Indexes available in SQL Server?
What is user defined datatypes and when you should go for them?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
