Solution : https://service.sap.com/sap/support/notes/1416955 (SAP Service marketplace login required)
Key words :
terms db2udb db2luw db6 optimizer activation sql x-table y-table navigation attribute characteristic performance sql0101n sql0101 db2_extended_optimization gy_delay_lookup gy_delay_expand reason, db2_extended_optimization=gy_delay_lookup db2_extended_optimization=gy_delay_expand, time-dependent attribute sid table, attribute sid table, db2_workload=sap db2_extended_optimization=nljoin_keycard, ixor [db2_workload] db2 luw v9, fix pack 9 db2 luw v9, removing navigation attributes, db2 optimizer generates, sap standard setting resolves
Related Notes :
| 1147821 | DB6: Known Errors and available Fixes in DB2 9.5 LUW |
| 977845 | DB6: Known Errors and available Fixes in DB2 9.1 LUW |
| 536223 | Activating master data with navigation attributes |
| 101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |