A good place to start... http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_bidw_optimizer_10gr2_0208.pdf On Wed, Dec 17, 2008 at 11:44 PM, hrishy <hrishys@xxxxxxxxxxx> wrote: > Hi > > I have a very simple query (which i should be able to post after i have > acesses to it) where the plan has changed NL using a index to Hash join on a > simple two table join after migrating to 10.2.0.3. > > My question is > Has anybody encountered such a situation after migarting from 9i to 10g RAC ? > Will oracle support guys help me if i give them the good and the bad plans > and the 10053 traces ? (is this covered as part of metalink support contract) > > I am clueless on how come a simpel two table join with no partitioning a > query could go bad. -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l