Tag: EXPLAIN

Can you guess how interesting the DSN_PREDICAT_TABLE really is?

DB2 z/OS literal replacement: Do you know the queries to list the Dynamic SQL which have literals or Parameter markers? Here is a very handy method to (fairly) quickly see if you have a literal problem that is killing the DSC

Tagged with: , , , , , , ,

GIVE and TAKE Program

Index Maintenance Costs, EXPLAIN Suppression, BIF Limited free-of-Charge Db2 Application This Program started in Europe, during our 30th anniversary was such a success, that it is now being Extended for the benefit of North American Db2 z/OS sites. SQL WorkloadExpert™ for

Tagged with: , , , , , , , , , , , , , ,