| Copyright © 1994, 2007, Oracle. All rights reserved. |  Previous |
 Next |
Within an aggregation specification, a MODEL statement executes a predefined model.
Syntax
MODEL modelname [PRECOMPUTE ALL | PRECOMPUTE NA]
Arguments
A text expression that contains the name of a predefined MODEL object.
Specifies whether the model is a static (precomputed) model or a dynamic model.
PRECOMPUTE ALL is the default and specifies a static model. The following conditions must be met:
Any RELATION or MODEL statements that precede it in the aggregation specification must also be specified as PRECOMPUTE ALL.
Any RELATION or MODEL statements that follow it in the aggregation specification can either be specified as PRECOMPUTE ALL or PRECOMPUTE NA.
PRECOMPUTE NA specifies a dynamic model. The following conditions must be met for runtime execution of the model:
All RELATION statements in the aggregation specification must appear before the MODEL statements specified as PRECOMPUTE NA.
Any additional MODEL statements that follow it in the aggregation specification must also be specified as PRECOMPUTE NA.
Examples
For an example of using a model in an aggregation specification, see Example: Solving a Model in an Aggregation.