Solution : https://service.sap.com/sap/support/notes/1526120 (SAP Service marketplace login required)
Key words : 
sysdbaprompt create column groupselect dbms_stats, experiencing long run times, sysdbacolumn col_group format a30select, create multi column histgrams, oracle text explain output, quicker star transformation plan, single table access calculation, gather column group statistics, star transformation execution plan, column groupexec dbms_stats
Related Notes : 
       
| 1576108 | Oracle 11g or higher: Extended CBO statistics |