Re: Informix external directives ?

Dirk Gunsthövel schrieb:
> Hi,
> 
> first you should be able to set the optimizer goal per session using
>   SET OPTIMIZATION FIRST_ROWS
> 
> secondly how do you see that the optimizer hints (that is what you
> mean, right?) are not used? Do you have any helpfull output?
> 
> (I had to use optimizer hints with Informix only in some rare
> occasions where the data structures where messed up and
> had to stay like that for some 'good' reasons ;-) )
> 
> Regards,
> Dirk
> 

Dirk,

I need to set the goal for a single query only. The overall goal 
ALL_ROWS is okay.

Further, I think SET OPTIMIZATION requires access to the source code of 
the third party product, which does not exist. Assume I could change 
optimization goal for a database session from outside. It would not 
help, because the third party product open and close database sessions 
dynamicly. I would never now what database session will run my "bad"
query.

Fyi, a query execution plan will give you informations about if a 
directive is used or not.

Regards ...

Joerg