Highlight look-ahead predicate generation (LPG)

A special type of transitive closure called look ahead predicate generation (LPG) may be costed for joins. In this case, the optimizer attempts to minimize the random I/O costs of a join by pre-applying the results of the query to a large fact table. LPG will typically be used with a class of queries referred to as star join queries, however it can possibly be used with any join query.

You can choose to highlight any icons that use LPG in the query graph.

To highlight LPG icons, select Highlight LPG from the View menu.