General

Hey all! We're having issues with the RPTEEACCT table. We're using RPT tables quite a lot for running reporting and then also querying those tables from other processes external to Relius. Working with our external DBA's we've seen when we run certain STP jobs it adds many many records (100's of millions in the case of RPTEEACCT) to the RPT tables and the constant deletes/inserts that are inherit with Relius code causes these tables to become fragmented. The outcome of all of this is that simple queries end up becoming full table scans which take far too long to run. Has anyone seen this before? It seems if we run 1 too many scheduled STP jobs things get pushed to run full table scans. Any help is greatly appreciated.