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 1, 2, 3

Give and Take 2020 Information on the Give and Take Programs 4,5,6,7   Previous Give & Take We have „GIVEn“ various free-of-charge Use Cases from our SQL WorkloadExpert for Db2 z/OS like:   1  Index Maintenance Costs   2  EXPLAIN

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