Re: select via dblink does not use index

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 04 Dec 2003 05:29:26 -0800
Message-ID: <F001.005D8C8D.20031204052926@fatcity.com>

Here are all the details:

Source database 9.2.0.4 (upgrade from 8.1.6.3.4). Target database 8.1.6.3.4.

View definition: create view my_view as select * from xx.lak_at_target_dblink.

Sql: select * from local_table , my_view where local_table.branch = 1
and my_view.customer = 20000000000 + local_table.branch * 100000000 + local_table.customer;

All tables are analyzed.

There are about 300 records in local_table and 1M records in remote_table. My_view.customer is primary key of target_table.

Where branch =1 is a set of 65 records.

Optimizer_mode=choose in both databases.

Explain plan: Hash join between FTS on local table and remote (in/out = serial).

Yechiel Adar
Mehish

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 04 2003 - 07:29:26 CST