Hello
I've received feedback that our extractions are quite slow.
Does anyone do any maintenance on the impresario_cci..T_CUST_KEYCODE table? I've noticed ours is huge (700+million rows) which can't be helping the speed of extractions.
Do you do anything regular to keep extractions working efficiently?
Thanks
Christine
Unknown said: Does anyone do any maintenance on the impresario_cci..T_CUST_KEYCODE table? I've noticed ours is huge (700+million rows) which can't be helping the speed of extractions. Do you do anything regular to keep extractions working efficiently?
After four years on Tessitura we noticed something similar earlier this fall, and have started purging rows from T_CUST_KEYCODE for extractions when they reach two years of age. All is working well for now, and we may shorten that time frame further at some point.