A select/omit set lets you select or omit records from a view based on data values in specified fields. Specifying a select/omit set for an access path is a two-level process.
You can specify none, one, or many select/omit sets for a given access path. Multiple select/omit sets are joined with a logical OR; in other words, once a record satisfies a select/omit set, other sets are not relevant.
Within each select/omit set, you define one or more conditions. Multiple conditions are joined with a logical AND; in other words, all conditions need to be true for the entire set to be true.
In this tutorial, there is only one select/omit set for each access path and only one condition attached to each.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|