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 -> Re: Optimization

Re: Optimization

From: rob van laarhoven <rob_at_dsdelft.nl>
Date: 2000/04/26
Message-ID: <956761360.741162@newsreader2.wirehub.nl>#1/1 






put


optimizer_mode=rule


into your init.ora and bounce the database.
But are you sure that's what you want?




> Thanks Rob. I tried that query in SQLPLUS,

> it came back as "CHOOSE". How do I set it

> to rule-based?

>

> David T.

>

Received on Wed Apr 26 2000 - 00:00:00 CDT












Original text of this message













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