View objects whose SQL Mode property is set to Declarative formulate their SQL statement at runtime rather than at design time. This behavior enables them to be informed of the set of attributes that the user wants to include in the result and, where possible, simplify the SQL statement through a combination of:
Removing columns in the SELECT list corresponding to view row attributes not selected
Removing tables in the FROM clause if the pruning rules allow