Hi All,



Does anyone have a list of the environemnt variables that control the
optimizer. I can't find anything in the SYS reference guide for 9.2 or
9.3.



Martin Bowes

On May 6, 2010, at 10:31 AM, Martin Bowes wrote:

I can't think of any environment variables that affect the optimizer.

DMF is the only facility that I know of which looks at environment
variables, and most of them appear to affect logging and recovery.
(Grep for NMgtAt.)

Karl

Karl Schendel wrote:

The only one that springs to mind that might useful is ING_SET, which
you can use to set things like:

SET JOINOP TIMEOUT n
SET CPUFACTOR n
SET PARALLEL n

I find CPUFACTOR quite useful for encouraging the optimizer to trade
extra CPU to get reduced disk I/O. Setting it to 1000 for instance will
cause OPF to devalue CPU costs to 10% of the normal value. If you
have a very fast CPU this is usually an excellent trade that can
result in significantly faster queries.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to https://www.regonline.co.uk/IUA2010 to register.

Hi Guys,

Thanks for the intel. After a bit of digging I came up with:

ingsetenv II_OPF_FORCE_TIMEOUT [0|1]
and set trace point OP248 max_cpu warn_cpu

I think I've come across a version of bug 106595 on an Ingres 9.2 site.

I particularly liked the part where I had to trash the installation with
kill -9's, do an ipcrm etc...

It's been fun lately.

Marty


-----Original Message-----
From: Karl Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: 06 May 2010 15:42
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Environment variables for the optimizer


On May 6, 2010, at 10:31 AM, Martin Bowes wrote:

9.3.
I can't think of any environment variables that affect the optimizer.

DMF is the only facility that I know of which looks at environment
variables, and most of them appear to affect logging and recovery.
(Grep for NMgtAt.)

Karl



_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres