What is the Significance of 'number of pass' es in a SQL?

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...

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.

Answer Question  Select Best Answer

I got an error in Microstrategy Report ...I shared the SQL with my Architect...He says he has trimmed the SQl and report is now working fine... Do any of you know how trimming a SQL is done?Thanks

madhuchandra

 Profile Answers by madhuchandra Questions by madhuchandra

• Jul 11th, 2008

HI,      Trimming the SQL is nothing but Optimizing the SQL by using Various VLDB Settings in the MSTR. i.e avoiding the cross join, removing multiple passes. Hope this as answered u r query.

Answer Question  Select Best Answer