On Wed, Aug 09, 2006 at 08:31:42AM -0400, Perez wrote:
> Every once in a while people talk about collecting better statistics, 
> correlating multi-column correlations etc.  But there never seems to be 
> a way to collect that data/statistics.  
> Would it be possible to determine the additional statistics the planner 
> needs, modify the statistics table to have them and document how to 
> insert data there?  We wouldn't have a good automated way to determine 
> the information but a properly educated DBA could tweak things until 
> they are satisfied.
> At worse if this new information is unpopulated then things would be as 
> they are now.  But if a human can insert the right information then some 
> control over the planner would be possible.
> Is this a viable idea?  Would this satisfy those that need to control 
> the planner immediately without code changes?

Sure, it's a Simple Matter of Code.

The real issue is figuring out what to do with these stats. I think all
the estimator fucntions could use improvement, but no one's taken that
on yet.
Jim C. Nasby, Sr. Engineering Consultant      [EMAIL PROTECTED]
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to