Hi Tim,

that would be a nice feature:

http://www.codinghorror.com/blog/archives/000638.html

Does not have to be fully automatic, but a list of fields that should be
indexed together with the time needed to execute the queries without these
indexes could be helpful. After playing with a system for some hours or
days, the indexes could be created using that list.

Ralf

Ralf,

<< Does not have to be fully automatic, but a list of fields that should be
indexed together with the time needed to execute the queries without these
indexes could be helpful. After playing with a system for some hours or
days, the indexes could be created using that list. >>

ElevateDB could be set up to log tuning information, and it could certainly
give some helpful advice based upon historical information on the
queries/filters that have been run.

--
Tim Young
Elevate Software
www.elevatesoft.com