How Many Ways Of Performance Tuning Are There In Sqr?

1.	How Many Ways Of Performance Tuning Are There In Sqr?
Answer» Using LOADF-LOOKUP & LOOKUP. Using ARRAYS. Using MULTIPE REPORTS. Using SQT Files. Using –Bnn COMMAND line Flag. Running on BATCH SERVER. Using PROPER Programming Logic in SQR such as Using BREAK statement in EVALUATE Command. Proper SQL tuning such as using SUB queries instead of Joins.

Answer»

Using LOADF-LOOKUP & LOOKUP.
Using ARRAYS.
Using MULTIPE REPORTS.
Using SQT Files.
Using –Bnn COMMAND line Flag.
Running on BATCH SERVER.
Using PROPER Programming Logic in SQR such as Using BREAK statement in EVALUATE Command.
Proper SQL tuning such as using SUB queries instead of Joins.

Discussion