Re: Slow query (only the first time)
From: joel garry <joel-garry_at_home.com>
Date: Fri, 13 May 2011 09:09:10 -0700 (PDT)
Message-ID: <1621f4bc-3076-46c5-bb9f-a1411f1508ef_at_22g2000prx.googlegroups.com>
On May 13, 4:49 am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com.invalid> wrote:
Don't use ansi joins.
Date: Fri, 13 May 2011 09:09:10 -0700 (PDT)
Message-ID: <1621f4bc-3076-46c5-bb9f-a1411f1508ef_at_22g2000prx.googlegroups.com>
On May 13, 4:49 am, "Álvaro G. Vicario"
<alvaro.NOSPAMTH..._at_demogracia.com.invalid> wrote:
MOS Bug 4169306: ANSI JOIN GIVES BAD PLAN COMPARED TO ORACLE JOIN
WORKAROUND:
Don't use ansi joins.
I'm sure that's not the only one, start googling...
jg
-- _at_home.com is bogus. http://www.theregister.co.uk/2011/05/11/oracle_buy_hadoop_cloudera/Received on Fri May 13 2011 - 11:09:10 CDT