Hi Experts,
I am eager to learn more on Performance tuning.
I have idea what actually explain plan does when we try to intrepret the sql Just have knowledge on wht measures will be shown in O/p for explain plan but not at the stage to decide based on measures/predicates/ what factors i need to consider into account.
There are other tools/options i came to find out which are SQL Trace and Autotrace are these both different from each other and also from explain plain.
On my Sql i did Auotrace to know how the ouptput looks like but i got nothing when i did explain plain i see some measures.
The below is o/p of Autotrace of my qeury.
