Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

Question

Quizplus · Accepted Answer

Indexes can slow down database performance during heavy updating activities, such as transactions, because they require additional resources to maintain. Therefore, they should be used carefully to balance the benefits of faster querying versus the costs of slower updates.

Indexes Should Be Used Judiciously for Databases That Support Transaction