Re: Different results for the same query in 10g and 11g

From: <>
Date: Wed, 18 Apr 2012 06:17:38 -0700 (PDT)
Message-ID: <18516615.315.1334755058536.JavaMail.geo-discussion-forums_at_vbhy1>

I had a same kind of problem. What versions are you using ? There are many bugs in I was told to upgrade to and after that I got the right result.

When using optimizer in 11g database I got the same result as in 10g. You could try SELECT /*+ OPTIMIZER_FEATURES_ENABLE('') */ hint in you query in 11g.


Maija-Leena Received on Wed Apr 18 2012 - 15:17:38 CEST

Original text of this message