Question: Suppose you have a large database with a table that contains a million records. You frequently need to search for records based on a specific
Suppose you have a large database with a table that contains a million records. You frequently need to search for records based on a specific field value. Which of the following is an advantage of creating an index on that field?
Question options:
The database will require less storage space
The index will speed up record retrieval in response to the search condition
The index will slow down record retrieval in response to the search condition
The database will become less secure
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
