Solution : https://service.sap.com/sap/support/notes/551400 (SAP Service marketplace login required)
Key words : 
transaction st04 st04 -> detailed analysis menu -> sql requests, terms rawfull table scan reason, prerequisites oracle solution paste, full table scan, explain plan shown, sql statement, oracle databases, st05 -> explain, execution path, cursor cache
Related Notes : 
       
| 1484708 | Performance in function module COM_PCAT_IMS_CP_INS | 
| 723879 | Explain: System displays an incorrect access path |