How can I optimize load

[Chris_Elders_VZ]

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);

[rwunderlich · Accepted solution]

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