Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 'RULE' based optimizer on certain tablespace?

'RULE' based optimizer on certain tablespace?

From: Helen <hhjin_at_yahoo.com>
Date: 4 Sep 2001 12:48:50 -0700
Message-ID: <ebcac1e2.0109041148.1dfc2269@posting.google.com> 





I have a 8.1.6 Oracle DB with optimizer set to be 'choose'.



Our application vendor suggested to set the optimzier
to be 'rule' based for a certain tablespace.



Any ideas how?



My understanding is that you can change the optimizer on
instance level, session or statement level (use /*).



Thanks



Helen
Received on Tue Sep 04 2001 - 14:48:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US