How to solve performance issue while inquiring material transaction distribution?

FORM "Find Material Transaction Distributions"
While we find transaction, query was too slow.

 

To run 'Gather Statistics'

The concurrent program can be run from the System Administrator Responsibility to generate statistics. To run this program:
1. Log on to Oracle Applications with the System Administrator responsibility.
2. Navigate to the Submit Request Window which is under the Navigation List Request > Run.
3. Submit the gather schema statistics program.
4. Enter the appropriate parameters. This can be run for specific schemas by specifying the schema name or entering 'ALL' to gather statistics for every schema in the databaGather Schema Statistics se.
5. Ensure there are no other concurrent jobs running at the time, else those jobs might complete with errors.

 

4月份以前查询1个月的数据只需几分钟，5月份以后需要1个多小时。运行并发请求“Gather Schema Statistics ”后查询1个月的数据不到1分钟。问题解决。经常运行这个并发请求可以改善EBS性能。