Hi All,
Need some suggestion/example on Explain Plan used by GATHER_PLAN_STATISTICS.
what E-rows , A-rows and A-Time telling?
can i use /*+ PARALLEL */ hint to the Select query? Because my Explain Plan is not showing TABLE FULL SCAN.
But it has INDEX RANGE SCAN/INDEX SKIP SCAN
The target table or index must be doing a full-scan operation,
BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Please suggest me on this.
Note: I have added my latest Explain Plan to the Reply# 16, can you please help me on this?
Thank You!
Message was edited by: Rajesh123 Note: I have added my latest Explain Plan to the Reply# 16, can you please help me on this?