©
Copyright, 2002 Howard F. Arner, Jr. All Rights Reserved. Unauthorized duplication prohibited.
Slide:
29
4/2/2002
Test for Performance
•
Run statement with debug on to see
optimizer messages
•
Check prepare, execute and fetch times
•
Verify that AS/400 is picking correct
path
•
Check for data type differences/access
path rejection messages