Choose indexes(2)

• Index overhead

• insert must insert records to every indexes
• update need to update related indexes
• disk space
• possible performance reduction during query optimization