1. index as much as possible all columns used in join and where clause.
2. Daily gather the statistics
3. DBMS_STATS is always better than ANALYZE TABLE
4. tables should be listed in from clause in such a way that oracle can start joining from smaller tables to bigger ones.
5. use of bind variable is always faster.
6. use Dynamic sqls as much as possible
7. in good tuned DB Cache hit ratios should be above 90
8. newer release faster than previous, so upgrade can boost performance
9. RAC can magically enchance performance.
10. A good DBA can always tune evry query and make it run from 1 hours to 1 min.
11. select count(1) is faster than select count(*)
12. Rebuild indexes daily.
2. Daily gather the statistics
3. DBMS_STATS is always better than ANALYZE TABLE
4. tables should be listed in from clause in such a way that oracle can start joining from smaller tables to bigger ones.
5. use of bind variable is always faster.
6. use Dynamic sqls as much as possible
7. in good tuned DB Cache hit ratios should be above 90
8. newer release faster than previous, so upgrade can boost performance
9. RAC can magically enchance performance.
10. A good DBA can always tune evry query and make it run from 1 hours to 1 min.
11. select count(1) is faster than select count(*)
12. Rebuild indexes daily.
Posts
