[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