If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Have you:
1) looked at it ?
2) found out what the differences are ?
3) thought about what it means ?

I am sorry, Please brief.. me. I am not well aware of that Plan table.
I am just studying the same.

But I changed the query as below and it finished very fast.
I created a small table and inserted the values from the MINUS
query.
and given the below query.
FROM ORDRHEAD,ORDRDETL WHERE ordh_no in(
select d.ordh_no from ordh_check d) and ORDH_STATUS='Y'
AND ORDH_NO = ORDT_ORDH_NO;

Originally posted by engiri I am sorry, Please brief.. me. I am not well aware of that Plan table.
I am just studying the same.

But I changed the query as below and it finished very fast.
I created a small table and inserted the values from the MINUS
query.
and given the below query.
FROM ORDRHEAD,ORDRDETL WHERE ordh_no in(
select d.ordh_no from ordh_check d) and ORDH_STATUS='Y'
AND ORDH_NO = ORDT_ORDH_NO;

which is finished below 1 second for 600 record.

First of all, did you find what is the differnce between "select col1, col2.." and "select count(*).." ???

Your execution plans tell it all.

Sanjay G.
Oracle Certified Professional 8i, 9i.

"The degree of normality in a database is inversely proportional to that of its DBA"