Re: Merge data from 10g database to 11g database
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Wed, 13 Jun 2012 13:12:49 -0600
Message-ID: <CAJzM94C2SxTf--fQQYnvXo-HXDG+z+nLJ1fF=Txia6D2bqdWpw_at_mail.gmail.com>
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.
Date: Wed, 13 Jun 2012 13:12:49 -0600
Message-ID: <CAJzM94C2SxTf--fQQYnvXo-HXDG+z+nLJ1fF=Txia6D2bqdWpw_at_mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 13 2012 - 14:12:49 CDT