Skip to Content
0
Former Member
Dec 04, 2008 at 06:56 AM

Cleaning up INDX table

773 Views

Hello Gurus,

Is there a way to trace the origin of records created in table INDX?

Currently there are 5 million records in INDX in our production system and I'm looking for ways to cleanup this table. Most of these recs do not have anything in field 'PGMID' and I'm not sure if we can trace the source where the recs are being generated.

Also, do you think it's an acceptable approach to just delete older records in order to trim the table?

Thanks. Hope to get some suggestions & insights from you all.