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>


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

Original text of this message