Re: Query gives incorrect results

Jim Kennedy wrote:
> You could read the docs and find out that you should never analyze
> the sys schema.
> Jim
>
>
>> This last case seems related to cost-based optimizer. Try again after
>> EXECUTE sys.dbms_utility.analyze_schema ('SYS', method=>'COMPUTE');
>> or
>> EXECUTE sys.dbms_utility.analyze_database (method=>'COMPUTE');

OTOH, the dbms_stats packe doesn't seem to have such a limitation.

Lots of Greetings!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"