SQL Efficiency

For each custom group element, there is at least one SQL pass. When the custom group element is expanded in the Custom Group Editor, up to three SQL passes must be made for each custom group element.

Since the Query Engine uses a smart algorithm to combine consolidation elements and determine the minimal number of SQL passes, only one SQL pass may be needed for all the consolidation elements.