This Case Study outlines the performance tuning techniques applicable to Custom development/support environments and illustrates them with the help of a case study of a successful Oracle report query performance-tuning carried out at one of our client site. Here we demonstrate how we successively tuned a non-terminating query operating on the real data to complete in less than 30 minutes.
The experiment carried out with a random subset of data containing 17 Million records exhibited 6.5x performance improvement. As the case study in this paper uses Oracle 10g as the database server, some of the performance tuning tips given in this paper would be specific to Oracle.
Keywords: Performance tuning, Tables, index tuning and
Author: Rajendra Kumar
Doyen Systems Pvt Ltd.