Dunno about others, but Microsoft SQL Server has the Database Engine Tuning Advisor which does exactly what you describe. You set it running for a while, or give it a sample workload, and it suggests indexes and statistics to create.
Kenny
The Wisdom of Amazon user reviews:
Kill Your Friends - John Niven
I was in one of the bands mentioned in this great book and we were at our most active in 1997.
Whipping Boy - Whipping Boy
We toured with Whipping Boy in the 90's and I thought they were very boring.
Neo Wave - Silver Sun
The greatest album ever made. This album is without doubt the greatest album of the 1990's, containing as it does the most uninhibited, most concise, most ear-bashingly beautiful tunes this side of hell.
[Guess the reviewer's band. Go on. Guess.]
|