When table contents change, indexes are readjusted
Slows down database insertion
Frequently accessed tables should not have too many indexes
Create indexes only when that index is likely to be used frequently
Indexes created may not be used to one's liking.
Determined by database optimizer by an algorithm
Indexes should have few common fields. Too many common fields would create problems for the optimizer
Use SQL Trace for determining indexes