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
- 5703 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 different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Explain the difference between primary keys and foreign keys?
Explain timestamp datatype?
Why are you getting errors when creating a new odbc dsn?
how many type of indexing in database?
Explain sql delete command?
How to execute multiple stored procedures at one time in sql server?
What are triggers in ms sql server?
How do you delete a data source?
How raid can influence database performance?
What are the new features in sql server 2016?
What is implicit cursors?
-
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)
