Re: Hints (Was: Index Tuning Features)

In article <20061012112647(dot)GD28443(at)phlogiston(dot)dyndns(dot)org>,
ajs(at)crankycanuck(dot)ca (Andrew Sullivan) wrote:

> On Thu, Oct 12, 2006 at 08:34:45AM +0200, Florian Weimer wrote:
> >
> > Some statistics are very hard to gather from a sample, e.g. the number
> > of distinct values in a column.
>

> I like the suggestion, though, that there be ways to codify known
> relationships in the system in such a way that the optimizer can
> learn to use that information.

Since there is already a genetic-algorithm based optimizer, is there any
way to use that to gather information to improve statistics?

For example, put the GA optimizer into a mode where it tries some of the
plans it comes up with and collects data on how they perform?

-arturo