Tweaking of SQL queries in DB2 - Use of Filter factor

Tweaking the SQL statements:  Ã˜       Tweaking is the process of changing a SQL statement without changing its functionality Ø       Filter Factor is a ratio that DB2

DB2 Access path Determination - Function of DB2 Optimiser

Function of DB2 Optimizer:  Ã˜       The Optimizer is the method by which DB2 chooses to carry out the data manipulation requested in the SQL statements Ø       DB2 Opt