With the script below I am trying to create a table that looks at the previous month and current months data. I am extracting the previous month because I will need to overwrite the previous month when month end close occurs. The Variable in the script is '2020-10-01' as a reference point. The about of data for each month is around 23-25million records each and it takes over 1.5 hours to extract. Is there coding that I can use to optimize the load time? The total number of fields when I do "select *" is about 100 fields.
LIB CONNECT TO 'EDW_EQUIP';
// MASTER MONTHLY BASE TABLE wSAP_FACT_V_CURRENT: select * from FINMAP_PRD_SECVM.wSAP_FACT_V
STORE * FROM wSAP_FACT_V_CURRENT INTO 'LIB://EQUIP/EQUIP_REPORTING_QVD/MASTERS/MONTHLY/wSAP_FACT_V_CURRENT.QVD'(QVD);