Siebel EIM
There are 33552897 records in EIM_LOY_TXN table and there are batch jobs that continuously populate this table. Though I have given the recommendation to archive/purge this table, client is not convinced about the need to do it. I searched in bookshelf for any benchmark for the count of records in EIM tables for the EIM job to perform optimally, but could not find anything.
Could you please provide a benchmark for the optimal number of records to be maintained in EIM table for the EIM job to perform optimally.