Hi,
On Wednesday 01 February 2006 18:19, you wrote:
> Clifford Wolf <[EMAIL PROTECTED]> writes:
> > However, it would be great to have get_restriction_variable() and
> > get_attstatsslot() extended so they can pass the most common values
> > from the statistics
'Y'
) WITH SELECTIVITY 0.9
AND loc.shortName = '5195'
However, it would be great to have get_restriction_variable() and
get_attstatsslot() extended so they can pass the most common values
from the statistics cache thru expressions, as described in my earlier
mail.
yours,
'CREATE INDEX clifford_temp ON contractelements ( upper(isActiv) )' followed
by an 'ANALYZE contractelements' solves the
problem in this particular case. But this is not a solution to the problem in
general..
Shouldn't the query planner be able to do the right thing wit
that sometimes executes fast and sometimes
hangs for hours until we kill the process.
yours,
- clifford
--
: Clifford Wolf Tel +43-1-8178292-00 :
: LINBIT Information Technologies GmbH Fax +43-1-8178292-82 :
: Schönbrunnerstr 244, 1120 Vienna, Austria
