RE: why rule based optimizer performs better than cost based?

  • From: Stephen.Lee@xxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 25 Jun 2004 10:12:52 -0500

> -----Original Message-----
> I found one query that runs faster when hint /*+ rule */  is added.

Here's another one:

select * from dba_jobs_running;

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: