A database administrator is optimizing a database with a large number of records. The database stores customer information, including their name, address, and purchase history. The administrator wants to improve query performance by indexing the database table properly. Identify the relevant attributes that should be indexed and explain why indexing them would improve query performance.

Answer rating: 100% (QA)

To optimize the database with a large number of records storing customer information including their name address and purchase history you should consider indexing certain attributes that are commonly ... View the full answer