SAP Note 1506237 - Long time to execute SQL from BICS_PROV_GET_MEMBERS

Component : BEx Web Java Runtime - MasterData read services

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

Key words :
long sql time solution, creating secondary index, terms attributes reason, encounter severe performance, solution root, sql triggered, complex sql, attributes selected, java environment, current implementation

Related Notes :

1498347BICS F4: Performance with authorization-relevant attributes
1466871Optimizing performance for "selection state" (GET_MEMBERS)
1413273Follow-on note for Note 1396346
1396346Performance F4: Secondary index for X/Y tables of a char.
1374724F4 and Check performance optimization
1144979RSD1: Deactivating attribute display in input help
875986Note Assistant: Important notes