This project default specifies that a temporary table is used to store the results of the query conditions.
-
Module(s) affected by this setting: Site > Fab Tracking > Maintain Fab Tracking.
-
List of Values: Y and N (default).
-
If set to Y, the results of the Where conditions defined on Global Setup > Query Builder - Where Conditions are stored in a temporary table. This method can be faster than the execution of the view in the SQL statement.
You should set this project default value as Y for complex Where conditions. For simple Where conditions, the default setting can be kept.
-