Previous Topic: GET_SORT_PRECEDENCE_STUB_1Next Topic: GET_TYPE_A_PRED_STUB_1


GET_TS_LOWER_BOUND_STUB_1

Purpose

Allows an additional restriction to be applied when choosing events as candidates for Review Queue by specifying an additional lower bound on EventTimeStamp. This will help performance on partitioned systems.

SQL Server default

None. No additional filter on EventTimeStamp is added.

Oracle default

In Oracle the EventTimeStamp predicate has already been considered by default to help query performance, particularly where partitioning is present, which should normally be the case. If there are no bounds input to the process or bounds are not available from any previous runs, then the minimum EventTimeStamp value is used as a lower bound.