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"