Re: performance question

"Pier Gaetano Novara" <pgaetanoNoSpam_at_csc.com> wrote in news: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
>
>
>

Are the two fields define EXACTLY the same datatype & length/precision? Please do
DESC TMP_TABLE_MERGE
DESC TMP_TABLE_1
and post the results Received on Sat Jan 04 2003 - 17:38:57 CET