SAP Note 1126400 - DB6: Statement Performance is bad due to MSJOIN

Component : DB2 Universal Database for Unix / NT -

Solution : https://service.sap.com/sap/support/notes/1126400 (SAP Service marketplace login required)

Key words :
terms db6 db2udb db2luw udb luw msjoin nljoin performance explain reason, 11619e+06            fetch                filter       ixscan   table, 11614e+06     ixscan             fetch                   ixscan   table, setting   cap offthis setting, db2 registry variable   db2_reduced_optimizationmust, db2 udb version 8, 11619e+06     ixscan     table, 125                      msjoin                        fetch, sapr3     ixscan   table, registry variable db2_reduced_optimization

Related Notes :

101809DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows