What is the use of an index?

Options
- Retrieve data more quickly and efficiently
- Related data requires much less I/O overhead if accessed simultaneously
- Simplify the user's perception of data access
- Both a and c

CORRECT ANSWER : Retrieve data more quickly and efficiently

Discussion Board
Database Index

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.

Prajakta Pandit 02-16-2017 06:31 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲