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
- 5759 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 is autocommit mode in sql server?
How do I find the default sql server instance?
How to connect sql server management studio express to sql server 2005 express?
How can you append an identity column to a temporary table?
What is a covered index?
What will you do If the low Performance occurs?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
What is dml command?
What you can do to delete a table without the delete trigger firing?
What factors you will consider calculating the storage requirement for that view?
How many index can be created for single table
4 Answers CarrizalSoft Technologies, Verizon,
How do you use a subquery to find records that exist in one table and do not exist in another?
-
Oracle (3259) - 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)
