In case someone else runs into this...
My performance issue is sporadic, and related to how the IBM i SQE is building the plan cache.
I have witnessed consecutive days where the SQE for these data sources, in Run SQL Scripts (RSS), uses indexes I've created. When used, the response time is 1-3 seconds.
Other times the SQE decides to build Temporary Hash Tables over very large files instead of using the corresponding indexes. When this occurs, the response time is 20+ seconds.
The IBM database group is looking at the issue.
My performance issue is sporadic, and related to how the IBM i SQE is building the plan cache.
I have witnessed consecutive days where the SQE for these data sources, in Run SQL Scripts (RSS), uses indexes I've created. When used, the response time is 1-3 seconds.
Other times the SQE decides to build Temporary Hash Tables over very large files instead of using the corresponding indexes. When this occurs, the response time is 20+ seconds.
The IBM database group is looking at the issue.
Comment