performance question
From: Pier Gaetano Novara <pgaetanoNoSpam_at_csc.com>
Date: Sat, 4 Jan 2003 14:31:45 +0100
Message-ID: <av6nnu$h5a$1_at_lore.csc.com>
Date: Sat, 4 Jan 2003 14:31:45 +0100
Message-ID: <av6nnu$h5a$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)
In both the table TMP_TABLE_MERGE and TMP_TABLE_1 the field OBJECT_ID is the
primary key but in the Explain Plan the table TMP_TABLE_MERGE is acessed in
full scan mode.
Do someone knows how can I force the use of the primary keys?
Thanks
Received on Sat Jan 04 2003 - 14:31:45 CET