Question

Select the correct answer.

Gina has created a banking database. She wants to index the Account Opened Date field. Why would she do that?
O A. to create a new record.
O B. to decrease the overall search time.
O C.
to sort that field
O D.
to create a link to another table.

Answer 1

Gina would index the Account Opened Date field in her banking database to decrease the overall search time. By indexing this field, the database management system can organize and structure the data in a way that facilitates faster retrieval of specific records based on their Account Opened Date. This eliminates the need to scan through all the records in the database to find the desired information, resulting in an optimized and efficient search process.

Step-by-step explanation:

Gina would index the Account Opened Date field in her banking database to decrease the overall search time. By indexing this field, the database management system can organize and structure the data in a way that facilitates faster retrieval of specific records based on their Account Opened Date. This eliminates the need to scan through all the records in the database to find the desired information, resulting in an optimized and efficient search process.

Learn more about indexing Account Opened Date field in a banking database