Query optimizer messages reference

 

See the following for query optimizer message reference:

• Query optimization performance information messages
  You can evaluate the structure and performance of the given SQL statements in a program using informational messages put in the job log by the database manager.

• Query optimization performance information messages and open data paths
  Several of the following SQL run-time messages refer to open data paths.

• PRTSQLINF message reference
  The following are the messages returned from PRTSQLINF.

 

Parent topic:

Performance and query optimization