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: franck <francois.bourdages_at_harfan.com>
Date: 21 Sep 2006 12:07:31 -0700
Message-ID: <1158865651.898434.140680@d34g2000cwd.googlegroups.com>

What is your RDBMS version ?
Did you check if there is a patchset for you ?

Almost every patch set i've seen have bugs fixed on CBO, hint, bad use of stat, etc. Received on Thu Sep 21 2006 - 14:07:31 CDT

This message: [ Message body ]
Next message: Brian Peasland: "Re: Oracle Database Diagram"
Previous message: Frank van Bortel: "Re: nested identifier"
In reply to: oracle10_at_gmail.com: "CBO picks wrong plan after analyze. FIRST_ROWS hint is workaround. ALL_ROWS causes wrong plan"
Next in thread: Jonathan Lewis: "Re: CBO picks wrong plan after analyze. FIRST_ROWS hint is workaround. ALL_ROWS causes wrong plan"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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