OraFAQ Forum: Performance Tuning » if RULE BASE exists in 11G

Home » RDBMS Server » Performance Tuning » if RULE BASE exists in 11G

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

if RULE BASE exists in 11G [message #297499]

Fri, 01 February 2008 02:48

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

thanks

Report message to a moderator

Re: if RULE BASE exists in 11G [message #297501 is a reply to message #297499]

Fri, 01 February 2008 02:54

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.

SQL> @v

Version Oracle : 11.1.0.6.0

SQL> set autotrace traceonly explain
SQL> select /*+ RULE */ * from t;

Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873

----------------------------------
| Id  | Operation         | Name |
----------------------------------
|   0 | SELECT STATEMENT  |      |
|   1 |  TABLE ACCESS FULL| T    |
----------------------------------

Note
-----
   - rule based optimizer used (consider using cbo)

But should you use it? No.

Regards
Michel

Report message to a moderator