2679143 - Fiori Launchpad initial startup is very slow - SAP ASE for Business Suite

• SAP Fiori Launchpad takes 30+ seconds just for Fiori to start
• It shows the message "Please Wait.." for a long time before anything changes.
• Initial Fiori Launchpad load after running the report /UI5/APP_INDEX_CALCULATE is very slow
• Per ST12, slow queries are the one of the following:

Program: /UIF/CL_LREP_DB_ACCESS_CDEP
Table: /UIF/LREPDEREFCD

SELECT DISTINCT  WHERE "CLIENT" = '100' AND ( ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=' ) AND "REF_TYPE" = 'UEP' AND "REF_SUBTYPE" = 'CONT' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'E' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'L' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'LY' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'MR' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI' AND "REF_SUBTYPE" = 'TY' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=' ) AND "REF_TYPE" = 'EMBEDDED' AND "REF_SUBTYPE" = '' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'VERSION' AND "REF_SUBTYPE" = '' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'ORIGLAYER' AND "REF_SUBTYPE" = '' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'APD' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek='  ) AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'APR' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'CENT' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'I' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=' ' ) AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'TYE' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'NO’)
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=')  AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'BSP’)
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'DATASOURCE' AND "REF_SUBTYPE" = 'OA' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'DATASOURCE' AND "REF_SUBTYPE" = 'ONO'  ) )
 /* R3:/UIF/CL_LREP_DB_ACCESS_CDEP===CP:5233 T:/UIF/LREPDEREFCD M:100 */ 

SELECT DISTINCT "REF_TYPE" ,"REF_SUBTYPE" ,"NAMESPACE" ,"NAME" ,"TYPE" ,"LAYER_TYPE" ,"CREATED_AT" ,"LAST_CHANGED_AT" ,"URI" FROM "/UIF/LREPVCCD" WHERE "CLIENT" = ? AND ( "REF_TYPE" = ? OR "REF_TYPE" = ? ) AND "REF_HASH" IN ( ? , ? , ? ) AND "LAYER_TYPE" IN ( ? , ? ) AND "HIDDEN" = ? /* R3:/UIF/CL_LREP_DB_ACCESS_CDEP===CP:4918 T:/UIF/LREPVCCD M:100 */  

SELECT "REF_TYPE" ,"REF_SUBTYPE" ,"NAMESPACE" ,"NAME" ,"TYPE" ,"LAYER_TYPE" ,"CREATED_AT" ,"LAST_CHANGED_AT" ,"URI" FROM "/UIF/LREPVC" WHERE ( "REF_TYPE" = ? OR "REF_TYPE" = ? ) AND "REF_HASH" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND "LAYER_TYPE" IN ( ? , ? , ? ) AND "HIDDEN" = ? /* R3:/UIF/CL_LREP_DB_ACCESS========CP:4879 T:/UIF/LREPVC M:330 */ /*unc. rd.*/

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite (BS)
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (BS)
• SAP NetWeaver 7.5

UI5, Fiori, launchpad, startup, slow, /UIF/LREPDEREFCD, "rsdb/max_blocking_factor", "rsdb/prefer_union_all", /UI5/APP_INDEX_CALCULATE, /UIF/LREPVCCD , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem