Home » RDBMS Server » Server Administration » Query on 10 g Migration issue
Query on 10 g Migration issue [message #331674] Fri, 04 July 2008 08:56 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
The rule based optimizer works in Oracle 9i, but is not supported in 10g.What is the other options?


Re: Query on 10 g Migration issue [message #331675 is a reply to message #331674] Fri, 04 July 2008 09:01 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

the Cost Based optimizer is where oracle are putting all their effort now but this relies on have uptodate statistics for tables indexes.

regards

Alan

[Updated on: Thu, 17 July 2008 11:16] by Moderator

Report message to a moderator

Re: Query on 10 g Migration issue [message #331677 is a reply to message #331675] Fri, 04 July 2008 09:06 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
You meant to say that this is the option for Oracle 10g?


Thanks,
Oli
Re: Query on 10 g Migration issue [message #331678 is a reply to message #331674] Fri, 04 July 2008 09:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again, have a look at documentation:
Database Performance Tuning Guide

Regards
Michel
Re: Query on 10 g Migration issue [message #331681 is a reply to message #331677] Fri, 04 July 2008 09:34 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

yes that is correct.

although I believe that you can still use the rule hint in sql scripts.

cheers

Alan
Re: Query on 10 g Migration issue [message #331688 is a reply to message #331681] Fri, 04 July 2008 10:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is in the doc I pointed.

Regards
Michel
Re: Query on 10 g Migration issue [message #331690 is a reply to message #331674] Fri, 04 July 2008 10:27 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
V10.2


  1* select /*+ RULE */ sysdate from dual
SQL> /

Execution Plan
----------------------------------------------------------
Plan hash value: 1388734953

---------------------------------
| Id  | Operation        | Name |
---------------------------------
|   0 | SELECT STATEMENT |      |
|   1 |  FAST DUAL       |      |
---------------------------------

Note
-----
   - rule based optimizer used (consider using cbo)
Previous Topic: Rebuilding Indexes
Next Topic: How Can find how much database is running in Oracle server
Goto Forum:
  


Current Time: Fri Dec 09 01:56:16 CST 2016

Total time taken to generate the page: 0.08971 seconds