Re: Problem with Informix 7.3 I need a good Idea very soon
Hi Klaus,
in this case you will have to deal with the different levels of
update-statistics, until you get what you want.
Try to do "typical" queries after 'set explain on;' in dbaccess and
try to figure out, why the optimizer takes a full-table-scan.
hth
martin
Bundesarchiv schrieb:
>
> not able to change the Source-Code
>
> MfG
> Ernst-Ludwig Brust
>
> NSI001 schrieb in Nachricht <19981125044133.19725.00000518@ng04.aol.com>...
> >Hallo Ernst-Ludwig Brust,
> >
> >why don't you use the Optimizer Directive "AVOID_FULL".
> >
> >MFG
> >
> >Klaus Nonne
> >nsi001@aol.com