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.
Above answer was rated as good by the following members: piya.s.singh
sqr performance is mainly depends upon sql accessing the database to increase the performance 1. we need to break the sql into pieces and put logic . avoid long joints.
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.
1 
0