Tags for large table
Need suggestions to optimize the complex query (below) involving several Joins and Aggregation..
Hi, I have below query which is failing in dev environment due to spool issue:   INSERT INTO D0_IM_RSTG_TAS_MD4.STG_TEMP_STOCK_DETAILS(MATERIAL_ID, VALUATION_AREA_ID, PLANT_ID, STORAGE_LOCATION_ID, CUSTOMER_ID, VENDOR_ID, WBS_ELEMENT_ID, FISCAL_PERIOD_CODE, BEGIN_DATE, END_DATE,
performance tuning aggregation joins union large table