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: CBO picks wrong plan after analyze. FIRST_ROWS hint is workaround. ALL_ROWS causes wrong plan

Re: CBO picks wrong plan after analyze. FIRST_ROWS hint is workaround. ALL_ROWS causes wrong plan

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 21 Sep 2006 12:48:06 -0700
Message-ID: <1158868086.382078.58180@d34g2000cwd.googlegroups.com> 





oracle10_at_gmail.com wrote:


> We have a query joining large and small tables. Small table has 130K

> rows. LargeTable has 4M (4 million) rows

>    0      SELECT STATEMENT Optimizer=HINT: FIRST_ROWS (Cost=170900 Car

>           d=42699 Bytes=1067475)




>    0      SELECT STATEMENT Optimizer=HINT: ALL_ROWS (Cost=19388 Card=4

>           2699 Bytes=1067475)




BTW how many rows you actually get back?



Gints Plivna


http://www.gplivna.eu
Received on Thu Sep 21 2006 - 14:48:06 CDT












Original text of this message













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