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 normalization? What are different type of normalization?
What do you understand by intension and extension?
How do you create a report in a database?
Why dbms is used?
What does fill factor concept mean with respect to indexes?
What is cardinality in db?
How to stop superserver service on linux using only firebird tools?
i need query for displaying the eno,ename in a table from row 2 to row 5
When we will denormalize data?
How do you maintain a database?
what are database files, control files and log files. How many of these files should a database have at least? Why?
What are records and fields 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)