What are indexes ? What are the advantages ? (Phone Screen)
Answer / ankit parikh
A database index is a data structure that improves the speed
of operations in a table.
Refer wiki: http://en.wikipedia.org/wiki/Index_(database).
One of the easiest sources to learn !
| Is This Answer Correct ? | 12 Yes | 1 No |
What is tuple and attribute?
What are the main functions of a database management system?
How do you create a database for an organization?
Why do not you use gnu autoconf or scons for building?
What is vacuum in database?
Is it possible to declare or create a cursor for update of table? If no tell me why?
Mention the differences between the clustered and non-clustered index
Define b-trees.
Can A column defined as PRIMARY KEY can have NULL values ?
What does partition mean in database?
What is the function of DML Compiler?
How do queries work in a database?
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)