Formal SQL Tuning for Oracle Databases

1. Introduction
Leonid Nossov, Hanno Ernst, Victor Chupis

2. Some Thoughts on the Term “SQL Tuning”
Leonid Nossov, Hanno Ernst, Victor Chupis

3. Minimum Minimorum on the Subject of the “Execution Plan”
Leonid Nossov, Hanno Ernst, Victor Chupis

4. Approaches to Formal SQL Tuning
Leonid Nossov, Hanno Ernst, Victor Chupis

5. Bottlenecks in the Execution Plan
Leonid Nossov, Hanno Ernst, Victor Chupis

6. Procedure of Formal SQL Tuning
Leonid Nossov, Hanno Ernst, Victor Chupis

7. Practical Experience with Formal SQL Tuning
Leonid Nossov, Hanno Ernst, Victor Chupis

8. Closing Remarks
Leonid Nossov, Hanno Ernst, Victor Chupis

Avainsanat: Computer Science, Database Management, Management of Computing and Information Systems, Computer Appl. in Administrative Data Processing