Ora DBA wrote:Usual questions...
RDBMS - 220.127.116.11. I'm running below insert statement from SQL Plus and right below query is its explain plan.
It's running too long, any suggestions please?
It will take a lot of time to do a NL join on 77m records. It could be due to that sql profile.
| 18 | NESTED LOOPS | | 43M| 4164M| | 320K (2)| 01:04:08 | | 19 | TABLE ACCESS FULL | ORDER_RELEASE_STATUS | 77M| 5894M| | 318K (1)| 01:03:38 | |* 20 | INDEX RANGE SCAN | XIE1_SNI_PA_OTM_ARC_DRVR | 1 | 20 | | 1 (0)| 00:00:01 |