Optimizer Statistics 

Thanks a lot for his very clear and valuable explanation. Would it be possible to have the slides you've used for it?. Thanks

Yes it's helpful👍👍👍

Nice Presentation.

Very bad explanation,just repeating the ppt. Nothing more

Thanks Please why is my last_analyzed query giving 0 rows selected. i just gather table stats. SQL> select last_analyzed from dba_tables where table_name='dept11' 2 ; no rows selected SQL> EXEC DBMS_STATS.gather_table_stats('ggtraining1', 'dept11') PL/SQL procedure successfully completed. SQL> select last_analyzed from dba_tables where table_name='dept11' 2 ; no rows selected

Great video, but you should stop underlining randomly. It confused more than it helped - at least for me.

such a poor explanation, just reading the slide twice...and that too no reading it correctly

dont just read the slide