For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
SQL stmt:
SELECT /*+ PARALLEL(r) */
r.c1 , r.c2
FROM table1 r
--> Table1 has 44 million records.
--> Explain plan is showing FULL TABLE SCAN