Skip to Content
0
Former Member
Aug 03, 2016 at 07:38 AM

Oracle update statistics for selected tables in SAP

679 Views

Hello,

We are using oracle 11g in our SAP ERP system. We had a problem with one business job for long sequential read of one business table. When checked for that table in DB20, last statistics was executed four months back. So we executed the statistics for that table alone in DB20 and scheduled the job again. The job is completed immediately.

Now we want to execute the statistics for selected business tables every week scheduling as a periodic job. Please let me know how we can achieve this.

Thanks and Regards,

Anand