Re: Merge statement not using index
From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Sat, 24 Mar 2012 20:59:56 +0000
Message-ID: <CAOuMUT7aDMB=-xjjit46AEOY7J3L7+DseD1Sy-waP2dppkHfUA_at_mail.gmail.com>
Hi,
Are you merging tables across db links? Joins across db links can be troublesome (and a merge would need to do a join). Try using a driving site hint to join on the target side and it might use the index.
Date: Sat, 24 Mar 2012 20:59:56 +0000
Message-ID: <CAOuMUT7aDMB=-xjjit46AEOY7J3L7+DseD1Sy-waP2dppkHfUA_at_mail.gmail.com>
Hi,
Are you merging tables across db links? Joins across db links can be troublesome (and a merge would need to do a join). Try using a driving site hint to join on the target side and it might use the index.
Regards,
Fergal
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 24 2012 - 15:59:56 CDT