Why does FINBI PROD: KPI YOY AR Comparison taking a very long time?
The query has to be optimized to solve the issue. Please check the below query and optimize it to improve the performance: SELECT DIM_AR_TXN_TYPE.TXN_TYPE_CODE,DIM_AR_TXN_TYPE.TXN_TYPE_DESC,DIM_DATE_GREG.MONTH_NAME,SUM(TRANSACTION_COUNT)"C1734", SUM(NET_TRANSACTION_AMOUNT)"C1735", SUM(TRANSACTION_COUNT_LY)"C1938", SUM(NET_TRANSACTION_AMOUNT_LY)"C1937", ' ' "C1940", ' ' "C1939" FROM AGG_AR_MLY,DIM_AR_LOCATION,DIM_DATE_GREG,DIM_AR_TXN_TYPE WHERE AGG_AR_MLY.DATE_KEY >=2215 AND AGG_AR_MLY.DATE_KEY