Explain plan in oracle
We have already posted on Autotrace in Oracle, tkprof, and sql trace. Here we will be looking for the Oracle Explain Plan utility and how we can effectively use it to tune the Oracle sql statement What is Explain Plan in Oracle Oracle database internally creates a query execution plan in order to fetch the …
Explain plan in oracle Read More »
