Scenario: Your database administrator recommends creating an index on a frequently used column to improve query performance. What is the potential downside of adding too many indexes to a table?

While indexes can significantly improve query performance, adding too many can lead to increased disk space usage, slower data modification operations (inserts, updates, deletes), and higher memory consumption. Additionally, excessive indexes can cause index fragmentation, leading to reduced query performance.