Re: PL/SQL Performance Issue or Slow Cursor?

That suggestion is only useful if you use RULE based optimizer. If it's CBO, use the /*+ ORDERED */ hint and try different orders of the tables again (and make sure you have good statistics).

Yong Huang
yong321_at_yahoo.com

vwu_at_anacomp.com (Vance Wu) wrote in message news:<c3d4638a.0109241217.5e3587e2_at_posting.google.com>...
> Michael,
>
> Thanks for your response, I did what you said to change the order of
> tables in the FROM clause, it didn't make any different, it still too
> slow.
Received on Tue Sep 25 2001 - 10:37:58 CDT