Does anybody know if the query optimizer can be turned off on v52 of os400 . we have built a logical file to directly query off to extract data from a physical file on the as400 .
what does the as400 do .. It goes away and uses a completely unsuitable logical and it takes hours to run .
the optimizer is picking up the wrong logical file/index.
can the optimizer be turned off .
i read something before about qaqqini in qusrsys
what does the as400 do .. It goes away and uses a completely unsuitable logical and it takes hours to run .
the optimizer is picking up the wrong logical file/index.
can the optimizer be turned off .
i read something before about qaqqini in qusrsys