Answered Questions

  • Performance tuning of SQR?

    bandisdevi

    • Nov 16th, 2010

    Simplify complex select statements.We can use load-lookup to simplify joins.Use dynamic sql instead of a condition in a select statement.One program can create multiple reports simultaneously.We can save compiled programs and return them with sqr execute.

    sandeep

    • Apr 4th, 2007

    For performance tuning in SQR first we need to tune up the sql,use appropriate joins with nessasary conditions.Then use nessasary functions for low execution time and use temp tables for bulk data transactions.