Is it safe to delete rows from PC_SUM_USE_TAO?
Is it safe to delete rows from PC_SUM_USE_TAO?
We're having a performance issue with app engine program that updates the PC_SUMMARY_TBL. The problem is in PC_SUM_RFSH2 at step 40000000.41000000.S.
The PC_SUM_USE_TAO tables has 13,121,872 rows. Based on the table name, it appears to be a temporary table. Although it is defined as a regular table in App Designer.
My thought is that I can help our performance if I can reduce the size of the table, but I'm not sure why the process leave rows in the table after it is done.