Building indexes over relational tables always has a positive effect on performance and never has a negative effect.

Question

Quizplus · Accepted Answer

Building indexes can have a positive effect on performance by making data retrieval faster, but it can also have a negative effect on performance by slowing down data modification (such as INSERT, UPDATE, or DELETE statements). Additionally, building too many indexes on a table can result in increased disk space usage and slower overall performance.

Building Indexes Over Relational Tables Always Has a Positive Effect