recategorized by
2,314 views

1 Answer

2 votes
2 votes

Answer A

Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index in the back of a book.

Refer this

http://www.tutorialspoint.com/sql/sql-indexes.htm

Answer:

Related questions

1 votes
1 votes
1 answer
3
Sankaranarayanan P.N asked Aug 2, 2016
2,083 views
Match the following database terms to their functions $:$$\begin{array} {clcl} & \textbf{List – I} && \textbf{List – II} \\ \text{(a)} & \text{Normalization} & \te...
1 votes
1 votes
3 answers
4
im.raj asked May 26, 2016
5,296 views
A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G}. Which of the following is a candidate key?AABABCAB...