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 the SUBSTR(SQUARE ANS ALWAYS WORK HARD,14,6) will return ?
Can you explain insert, update and delete query?
Why its better to use files than a DBMS when there are multiple users to access the data
Can we store images in database?
How do you handle your own transaction?
How does index hunting help in improving query performance?
What is default value database?
If CPU is very slow What can u do to speed up?
Explain what is meant by asymmetrical protocols?
How do I create a database?
Where is data stored in database?
What are the 4 main objects of a database?