Question

From: Pier Gaetano Novara <pgaetanoNoSpam_at_csc.com>
Date: Sat, 4 Jan 2003 14:20:33 +0100
Message-ID: <av6n2u$gpc$1@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
Pier Received on Sat Jan 04 2003 - 07:20:33 CST