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 |