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