Re: Merge statement not using index

From: Fergal Taheny <ftaheny@xxxxxxxxx>
To: sbecker6925@xxxxxxxxx
Date: Sat, 24 Mar 2012 20:59:56 +0000

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


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

References:
- Merge statement not using index
  - From: Sandra Becker
- Re: Merge statement not using index
  - From: Igor Neyman
- Re: Merge statement not using index
  - From: Sandra Becker

Other related posts:

» Merge statement not using index- Sandra Becker
» Re: Merge statement not using index- Igor Neyman
» Re: Merge statement not using index- Sandra Becker
» Re: Merge statement not using index - Fergal Taheny
» Re: Merge statement not using index- GovindanK
» Re: Merge statement not using index- Sidney Chen
» Re: Merge statement not using index- Sandra Becker