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: RULE vs CHOOSE

Re: RULE vs CHOOSE

From: Dreamloop <dreamloop_at_aol.com>
Date: 1997/08/11
Message-ID: <19970811143301.KAA22212@ladder02.news.aol.com>#1/1

Hi Rowan,

 If your tables are not being analyzed it is better to set the optimizer to RULE.

The CHOOSE option would just add overhead in that scenario.

There are not stupid questions, just stupid answers !!

Robert Received on Mon Aug 11 1997 - 00:00:00 CDT

Original text of this message

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