Nov 182015
 

Basic Tuning for SQL Query   Ordering of the FROM clause.  When we are fetching data from more than one table, write the table with fewer rows at the end of the FROM clause. Therefore, the table returning the least number of rows should be last in the FROM list. Example: SELECT COL1 FROM TAB1,

[Read More]
Dec 012014
 

Performance Tuning on SQL and PL/SQL Performance Tuning can be performed by following few guidelines: 1. Database must be normalized which will help to decrease the storage requirement and faster search performance. Normalization Normalization is the process of efficiently organizing data in a database. It deals with elimination of redundant i.e. duplicate data and ensures

[Read More]