Index not being used

From: Devinder <devinder_pal.singh_at_pharma.novartis.com>
Date: Thu, 29 Jul 1999 17:03:25 -0400
Message-ID: <37A0C19D.C56C040@pharma.novartis.com>

Dear all,

I am running this query

delete from case_master_at_bs04 a where exist (select 'x' from case_product b where b.case_id = a.case_id);

ie table a is remote and table b is local

When I do an explian plan it shows a full tablescan for case_product ie my local table and if I create the case_master table locally then it starts using the index for table b. Can somebody explain that or some other way to format this quiery except creating snapshots or creating a local table.

TIA
Daveinder Received on Thu Jul 29 1999 - 16:03:25 CDT