[rt-users] Oracle 9 and Build.html performance

Joop JoopvandeWege at mococo.nl
Tue Jan 22 07:16:26 EST 2008


Emmanuel Lacour wrote:
> SQL> set autotrace on
> SQL> CREATE INDEX Groups3 ON Groups (LOWER('Type'), LOWER('Domain'), Instance);
> Index created.
> SQL>   execute dbms_utility.analyze_schema( 'RT', 'estimate');
>   
Any particular reason to run 'estimate' instead of 'compute' ?

Further your output of Oracle10g looks almost identical/is identical to 
the output of Oracle9. That sounds to me like a copy/paste problem 
because that is not what I expect and contradicts your own statement 
that Oracle10 is faster than Oracle9.

Joop




More information about the rt-users mailing list