Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.

Hi Karl,

Thanks for getting back to me.

I had a bit of a look through the documentation and from what I read it says
that parallel processing is also controlled in cbf through the "opf_pq_dop"
and a value greater than one means it is on.

I only just installed Ingres and the default was 8 for this parameter. I
might just reset to 0 just for the hell of it to see what happens. I am
working on a new server that I have all to myself so I can go a little crazy :
)


regards,

Dominic

Karl & Betty Schendel wrote:
Hi all,

[quoted text clipped - 6 lines]
Is this related to parallel query processing? Do I need to be worried about
this?

You don't need to worry, but it does indicate a potential problem with
the greedy optimizer heuristic, and probably should be reported.

The optimizer falls back to the standard enumeration, so your queries
will continue to run. They'll waste a little extra time in the
optimizer, not much.

It has nothing to do with parallel query processing, which is off
by default. (You have to ask for it with "set parallel".)

Karl

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/ingres/200609/1

.

Relevant Pages

  • Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
    ... Dominic Merrin via DBMonster.com wrote: ... I had a bit of a look through the documentation and from what I read it says ... default target level of parallelism when parallel query is turned on. ... The optimizer falls back to the standard enumeration, ...
    (comp.databases.ingres)
  • Kyan Optimizer
    ... Has anybody a documentation about the kyan pascal's OPTIMIZER? ... Guillaume. ...
    (comp.sys.apple2)
  • Re: passing variables through fminunc or fminsearch
    ... the function name in the optimizer call, ... I saw that in one of the examples in the MatLab ... documentation. ... As Steve said, ...
    (comp.soft-sys.matlab)
  • Re: UPDATE syntax question
    ... Specifically in an EXISTS clause, the optimizer will just test for the ... existence of any rows, and not worry about what columns were specified. ...
    (microsoft.public.sqlserver.programming)