Archive for tuning
You are browsing the archives of tuning.
Oracle performance tuning – an update
A tutorial is now available to perform Oracle performance tuning of applications and SQL statements. This tutorial has been expanded to include case studies, which will go a long way in better understanding of concepts explained. Link to the PDF tutorial here: Tuning.pdf This current posting is an extension to the existing post on performance [...]
Performance tuning SQL queries in Oracle
Video tutorial showing how to optimise your SQL queries for maximum performance. Talks about indexes, statistics, hints and optimiser plans.
Using SQL potential
How to use the database SQL to its full potential. The idea is to reduce procedural coding and thereby improve performance, reduce defects.
