1. A method for selecting optimized indexes for a relational database, comprising: (a) collecting data about all database queries in a representative time interval; (b) determining database tables which have been queried during the representative time period so as to have triggered activity above a predetermined amount; (c) computing an optimized index set based on table read/change activity; and (d) recommending the optimized index set to a user.