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 is openedge translation manager?

623


Explain the different types of languages that are available in the dbms?

569


Why is databases important in healthcare?

612


What do you mean by buffer manager?

597


Mention the differences between the clustered and non-clustered index

585






What do you understand by data model?

608


What is data in dbms?

599


What are the different types of languages that are available in the dbms?

682


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping

1393


What is an artificial (derived) primary key? When should it be used?

551


What is a functional dependency in the dbms?

566


Enlist some commands of ddl?

598


I want to export the data date to date from oracle database then what can i do?

2069


What are the two types of database?

549


Explain meant by 3-tier architecture?

599