What are indexes ? What are the advantages ? (Phone Screen)



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

Post New Answer

More Database Management Interview Questions

what the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?

3 Answers   Citrix, SAP Labs,


Can you explain insert, update and delete query?

0 Answers  


Why its better to use files than a DBMS when there are multiple users to access the data

0 Answers   Infosys,


Can we store images in database?

0 Answers  


How do you handle your own transaction?

0 Answers  






How does index hunting help in improving query performance?

0 Answers  


What is default value database?

0 Answers  


If CPU is very slow What can u do to speed up?

1 Answers  


Explain what is meant by asymmetrical protocols?

0 Answers  


How do I create a database?

0 Answers  


Where is data stored in database?

0 Answers  


What are the 4 main objects of a database?

0 Answers  


Categories