Sql optimization

This course is a brief description of Oracle SQL tuning. However, it is not an exhaustive compendium of knowledge on this issue. Its mission is to provide the reader with some information on practical experiences with tuning.

With increasing demand for performance systems in a 24/7 need to efficient operation of SQL commands in the production system becomes even more important. When you enter a new SQL command, make sure that it will be carried out efficiently. The introduction of the new index is the need to ensure that existing SQL commands will use it properly.

Many centers now use software packages from different vendors. SQL Tuning for these applications can not rely on placing hints in SQL statements, because the user is not authorized to modify the application code. Of course, for the same reasons you can not rewrite SQL code. But we should not forget that there is still a lot of tips and hints to help with the final tuning software.

1. SQL optimizers
   
2. RBO secret #1
3. RBO secret #2
4. RBO secret #3
5. RBO secret #4
6. RBO secret #5
7. RBO secret #6
8. RBO secret #7
9. Cost-based optimizer
10. Tuning the database before entering the production phase
11. Histograms
12. Common misconceptions of the optimizers
13. Choice of Optimizer
14. Problems in the use of rule-based optimizer
15. Problems with using cost-based optimizer

to be continued...