In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster