Re: CBO question ?
- From: "Ram K" <lambu999@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxxxxx
- Date: Thu, 2 Mar 2006 15:46:06 -0500
If Oracle is going to use CBO for partitioned tables by default, how does it
work in the case of absence of statistics?
Does it collect statistics at runtime? Usually partitioned tables tend to
be big. I am interested to know how it works.
Thanks.
Ram.
On 3/2/06, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
>
> There can be other triggers too:
> CHOOSE will use CBO if *any* one of these is true:
> - At least one table in the query has statistics
> - A table has CBO-only characteristics:
> - table is an IOT
> - table is partitioned
> - table has parallel degree greater than 1
>
> Also, there may be other triggering events that invoke CBO.....
>
> -Mark
>
>
> *--*
> *Mark J. Bobak*
> *Senior Oracle Architect*
> *ProQuest Information & Learning*
>
> "Exception: Some dividends may be reported as qualified dividends but are
> not qualified dividends. These include:
>
> • Dividends you received on any share of stock that you held for less than
> 61 days during the 121-day period that began 60 days before the ex-dividend
> date. The ex-dividend date is the first date following the declaration of a
> dividend on which the purchaser of a stock is not entitled to receive the
> next dividend payment. When counting the number of days you held the stock,
> include the day you disposed of the stock but not the day you acquired it.
> See the examples below. Also, when counting the number of days you held the
> stock, you cannot count certain days during which your risk of loss was
> diminished. See Pub. 550 for more details."
>
> --IRS, Form 1040-A Instruction Booklet, Line 9b: Qualified Dividends
>
>
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Igor Neyman
> *Sent:* Thursday, March 02, 2006 11:47 AM
> *To:* Venu.Andem@xxxxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: CBO question ?
>
>
> You are wrong.
>
> Igor
>
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Andem, Venu
> *Sent:* Thursday, March 02, 2006 11:41 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: CBO question ?
>
> Paul,
>
> I think its the other way round, if one of the tables in the query does
> not contain statistics then Oracle uses RBO. pls correct me if i am wrong.
>
> Venu
>
> -----Original Message-----
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *Baumgartel, Paul
> *Sent:* 02 March 2006 15:31
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: CBO question ?
>
> If any table mentioned in the query has statistics stored in the data
> dictionary, Oracle will use the CBO.
>
>
> *Paul Baumgartel*
> paul.baumgartel@xxxxxxxxxxxxxxxxx
> 212.538.1143
>
> -----Original Message-----
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *Savio Pinto (s)
> *Sent:* Thursday, March 02, 2006 10:28 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* CBO question ?
>
> Hi,
>
> The execution plan for a query in oracle 9i shows "Optimizer= CHOOSE", how
> can i force the DB engine to use the COST based optimization for a query ?
>
> Oracle version is 9.2.0.4.0
>
> Thanks
> Savio Pinto
>
> ==============================================================================
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ==============================================================================
>
>
> PLEASE NOTE: THE ABOVE MESSAGE WAS RECEIVED FROM THE INTERNET.
>
> On entering the GSi, this email was scanned for viruses by the Government
> Secure Intranet (GSi) virus scanning service supplied exclusively by Cable &
> Wireless in partnership with MessageLabs.
>
> Please see http://www.gsi.gov.uk/main/notices/information/gsi-003-2002.pdffor
> further details.
>
> In case of problems, please call your organisational IT helpdesk
>
> *Land Registry at Homebuyer Show, 17-19 March, ExCeL London*
>
>
>
> If you have received this e-mail and it was not intended for you, please
> let us know, and then delete it. Please treat our information in confidence,
> as you would expect us to treat yours.The Land Registry checks all mail
> and attachments for known viruses, however, you are advised that you open
> any attachments at your own risk.
>
>
>
> The original of this email was scanned for viruses by the Government
> Secure Intranet (GSi) virus scanning service supplied exclusively by Cable &
> Wireless in partnership with MessageLabs.
>
> On leaving the GSi this email was certified virus-free
>
--
Thanks,
Ram.
Other related posts:
