Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Performance checks while coding embeded SQL's

    Want to know some basic performance checks which should be done while coding the embeded SQL's.

  2. #2
    Join Date
    May 2003
    Use the EXPLAIN YES option on the BIND command. This will populate the explain tables for static SQL (you have to make sure the explain tables are created if not already done so). Once the explain tables are populated, you can use the visual explain feature to analyze the access path of your SQL.

    There are other explain options that can be used during the BIND process, so consult the manual for details. Make sure you use the option that does not create explain output during each program execution for any dynamic SQL (unless that is what is desired).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts