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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
