SAP Note 1091419 - DB6: Poor Performance for queries with FOR ALL ENTRIES

Component : DB2 Universal Database for Unix / NT -

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

Key words :
db2 optimizer incorrectly processes open sql queries, rsdb/prefer_join=0rsdb/prefer_in_itab_opt=1alternatively, individual open sql statements, profile parameter rsdb/prefer_join=1, optimizer errors mentioned, suitable db2 fixpack, db2 version 8 fixpak 14, db2 version 8 fixpak 15, sql queries, 00 sap kernel supports

Related Notes :

48230Parameters for the SELECT ... FOR ALL ENTRIES statement