Hi Gurus,

I am trying to insert around 2 lakhs of records in two different tables
from a single select statement using multi table insert feature of oracle 9i
and the insertion is conditional i.e I am using WHEN clause. The when clause
is based upon an indexed column. But the execution path of the query is
showing that the index is not used and it is Full table scan. Now my
question to you is that when we use WHEN clause in multi table insert then
whether index is used or not?

Thanks & Regards.
Sudipta

Oracle LazyDBA home page