Schlagwort: EXPLAIN

2019-03 EXPLAIN data review

Db2 EXPLAIN example: a quick history of EXPLAIN and a new standard Db2 EXPLAIN Query to bring out the best and most underused columns.

Getagged mit: ,

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

Getagged mit: , , , , , , ,

GIVE and TAKE Programme

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

Getagged mit: , , , , , , , , , , , , , , ,