How can I optimize load

Chris_Elders_VZ — Sat, 16 Nov 2024 17:50:06 GMT

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

WHERE WSAP_POST_MTH>='$(VPERIOD)';

STORE * FROM wSAP_FACT_V_CURRENT INTO 'LIB://EQUIP/EQUIP_REPORTING_QVD/MASTERS/MONTHLY/wSAP_FACT_V_CURRENT.QVD'(QVD);

Re: How can I optimize load

rwunderlich — Thu, 12 Nov 2020 23:40:31 GMT

Does the database table have an index for the WSAP_POST_MTH column? If not, creating an index on this column or using an already indexed column would speed up the query.

-Rob

topic How can I optimize load in App Development

How can I optimize load

Re: How can I optimize load