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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are indexes? What are b-trees?

476


How view is related to data independence?

505


What is entity and its types?

497


Is database a data structure?

465


What is a functional dependency in the dbms?

470






dear sir please provide what question will be asked in bank it officer interview

1711


What methods is used to commit the changes made in DataSet object?

505


What is domain in dbms?

535


What is a clustered database?

492


What do you understand by the view and mention the steps to create, update and drop a view?

462


Explain the types of database normalization?

476


Why are forms important in databases?

472


What's difference between dbms and rdbms ?

548


What is a system concept?

492


What is db flush?

474