In compliance of the Housekeeping guidelines for Optimization of critical Ingres Databases and Tables for Production servers, this activity will cover the following:\n\n1. Identify which production database to be used for pilot implementation.\n2. Identify fast growing and critical tables in production database.\n3. Rollforwarddb the production database into the test server.\n4. Benchmark the identified tables in the test server.\n5. Create a plan and schedule of the optimization activity base on the result of the benchmark.\n6. Propose the plan and schedule which will be subject for approval of all concerned department.\n7. Implementation of the plan and schedule in the staging / reporting / test server.\n8. Implementation of the plan and schedule in the production database.