An index purports to speed data retrieval. You, therefore, index every attribute in each table. Select the likely consequence.
Answer – Data entry slows as evert INSERT, UPDATE, or DELETE statement must also update every index.
(The optimum number of indexes for an OLTP application is zero. If you normalize, you must have a Primary Key. A Primary Key is enforced through an index. One index is now justified. You need an attribute to be unique. Uniqueness is enforced through the use of an index. A second index is justified. After that, your business reason should justify the overhead of both entering data and updating the index. Reporting is usually best done through an OLAP database that uses a star schema and lots of indexes for optimized data retrieval.)