> > However, I do think that a utility to examine a given workload and

suggest

> > indexes would be a useful thing to have in my toolkit.
>
> So at least we agree at this point.

:-)

Check out

http://research.microsoft.com/db/AutoAdmin/

for a few ideas on how the topic might be approached (specifically, the last
paper presented).

Marcelo Lopez Ruiz