sapna_321

 Profile Answers by sapna_321 

• Nov 29th, 2009

 

Fewer the passes the faster the report will run.

vidhya

• Feb 15th, 2012

 

Passes in mstr helps in testing the mstr query at the back end.
It gives clear idea on the calculations, levels.

From performance tuning point of view, the SQL pass option should be unchecked to avoid mstr from creating lot of temporary tables and thus reducing the performance of the report.

Mahipal

• Oct 19th, 2012

 

Passes in SQL lets the developer understand the report from SQL stand point. The more the passes the more the excecution time and vice versa. SQL passes also lets the developer know the actual flow of the execution, if the developer is capable of breaking down the passes and understand the report , he can easily maintain that report with minimal amount of time.