Re: Merge data from 10g database to 11g database

  • From: Sandra Becker <sbecker6925@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Jun 2012 13:12:49 -0600

Doing some tracing, looking at AWR, execution plans.  I see that the merge
is now doing FTS on the archive tables where it was using indexes before.
 Any way to force it to use the primary key index like it was before the
upgrade?
Sandy
Transzap, Inc.


--
//www.freelists.org/webpage/oracle-l


Other related posts: