Question
From: Pier Gaetano Novara <pgaetanoNoSpam_at_csc.com>
Date: Sat, 4 Jan 2003 14:20:33 +0100
Message-ID: <av6n2u$gpc$1_at_lore.csc.com>
Date: Sat, 4 Jan 2003 14:20:33 +0100
Message-ID: <av6n2u$gpc$1_at_lore.csc.com>
I have this statement:
DELETE FROM
TMP_TABLE_MERGE
WHERE EXISTS
(SELECT 1 FROM
TMP_TABLE_1 T1
WHERE
TMP_TABLE_MERGE.OBJECT_ID = T1.OBJECT_ID)
[Quoted] [Quoted] In both the table TMP_TABLE_MERGE and TMP_TABLE_1 the field OBJECT_ID is the
[Quoted] [Quoted] primary key but in the Explain Plan the table TMP_TABLE_MERGE is acessed in
full scan mode.
[Quoted] Do someone knows how can I force the use of the primary keys?
Thanks
Pier
Received on Sat Jan 04 2003 - 14:20:33 CET