Tuesday, June 8, 2010

Customer Interface Performance Tips

1) Define "HZ: Number of Workers Used by Customer Interface"

2) Use Customer Interface Master Conc Program (RACUSTMA) instead of "Customers Interface" (RACUST)

3) Set "HZ: Gather Table Stats" the Profile Option set to "YES".

4) Run Gather Schema Stats program and Rebuild all AR Indexes with online clause

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.