By Maria Colgan-Oracle on May 12, 2011
Let me provide a little background to this question before answering it.
This application is a home-grown Java based app and the SQL statement in questions looks like this:
INSERT /*+APPEND*/ INTO t1
(ROW_ID, MODIFICATION_NUM, OPERATION, LAST_UPD)
SELECT ROW_ID ,1 ,'I' ,LAST_UPD
WHERE t2.LAST_UPD > :1;
The table T2 has approximately 1.4 million rows and one index IND_T2 on the LAST_UPD and ROW_ID columns. The execution plans are quite simple and involve just the IND_T2 index. The paln in SQL* Plus does an index range scan on the IND_T2 index.