Just a random thought... are there any databases out there which profile all the queries that are run and are capable of auto-creating or suggesting indexes that would be worthwhile creating?
Seems like they already do much of this work, and it wouldn't take a great deal to store any relevant info, analyse it every so often, and offer suggestions for indexes which could be implemented and tested for improvements.
Is there anything I'm missing for why this isn't done?
EDITED: 2 Sep 2009 14:33 by BOUGHTONP