From: | Leon <leon(at)udmnet(dot)ru> |
---|---|
To: | "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)hub(dot)org> |
Subject: | Re: [GENERAL] Fast join |
Date: | 1999-06-29 17:54:23 |
Message-ID: | 3779084F.9F5149EB@udmnet.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bruce Momjian wrote:
>
> > Ok. It seems that statistics which is within optimizer's reach is quite
> > poor, so optimizer can't always make sane predictions. And, I am
> > afraid, improving statistics gathering will require major rewrite of code.
> >
> > So there should at least be some way to give hints to optimizer,
> > shouldn't it?
>
> Currently, no way to give hints.
Picture this:
SELECT * FROM atable,btable WHERE
atable.cfield = btable.cfield AND #(atable.afield>10)#
Where "magic brackets" will tell optimizer that qualification
atable.afield>10 is very restrictive and should be treated on a par
with "=" qualification. Such hint seems much easier to realize
than to make optimizer gather real statistics on a table during
decision process.
--
Leon.
From | Date | Subject | |
---|---|---|---|
Next Message | abdelkrim | 1999-06-29 18:14:30 | how to change delimiter single-quote ? |
Previous Message | Bruce Momjian | 1999-06-29 17:33:46 | Re: [GENERAL] Fast join |