Answered Questions

  • Sep 11 2008
    07:52 AM
    9894
    6

    Significance of pass in SQL
    • bforbi

    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.