Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
- From: "Roy Hann" <specially@xxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Sep 2006 10:11:22 +0100
"Dominic Merrin via DBMonster.com" <u9483@uwe> wrote in message
news:662c259c20af7@xxxxxx
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.
Not quite. A value greater than zero means the server is capable of running
parallel threads to execute a query. But you still need to SET PARALLEL to
invite it to execute your session's queries using parallel threads.
Roy
.
- References:
- Enhanced enumeration technique failed to find valid query plan.
- From: Dominic Merrin via DBMonster.com
- Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
- From: Karl & Betty Schendel
- Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
- From: Dominic Merrin via DBMonster.com
- Enhanced enumeration technique failed to find valid query plan.
- Prev by Date: Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
- Next by Date: Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
- Previous by thread: Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
- Next by thread: Re: [Info-ingres] Enhanced enumeration technique failed to find valid query plan.
- Index(es):