ANALYZE vs DBMS_STATS
Oracle recommends to use DBMS_STATS instead of ANALYZE since 8i. Sometimes, we might get confused by the two similar tools. So I took some times… Read More »ANALYZE vs DBMS_STATS
Performance Tuning
How to Find Most Expensive SQL
With a demanding database, you may want to know how to find out the most expensive sqls. Running on Oracle, we have Cost-Based Optimizer, the… Read More »How to Find Most Expensive SQL