Thursday 31 October 2013

Difference Between Filter & Selection Step

All,

Applying filters in reports may seem similar to selection steps.
see bellow image














Filters:
• Are always applied on all views.
Selection Steps:
• Are applied only if the corresponding column is included in the view.
• May generate additional logical and physical queries.

Look at bellow screen shots :













But see what happens when columns are removed from tables -


























Next Time ..

No comments:

Post a Comment