5 SQL tuning Strategies - DB2

Tuning Strategies:   Ø       Tuning Strategy 1: ü       Adjust the COLCARD, FIRSTKEYCARD and FULLKEYCARD columns to an artificially high value. Reason: ü&nbs

Tuning of SQL queries in DB2 when RUNSTAT is not feasible

Updating the DB2 Catalog Statistics: Ø       This method of tuning is chosen whenever standard methods (RUNSTATS) of influencing the DB2’s access path selection are not satisfactory.  Ø 

Tuning and optimisation of SQL in DB2 - Tips and Tricks

Most SQL queries are written with little importance to performance tuning. Often, this is not a problem when programs are tested in test environment, where performance is not an issue. But, production environments calls for lesser execution