Function of Predicate_Field
Associates the list of columns specified in a captured predicate with the parent relation and predicate.
Predicate_Field Table Definition
The following CREATE TABLE request defines the Predicate_Field table:
CREATE TABLE predicate_field ( PredicateID INTEGER NOT NULL, RelationKey INTEGER NOT NULL, FieldID INTEGER NOT NULL) PRIMARY INDEX ( RelationKey );
Attribute Definitions for Predicate_Field
The following table defines the Predicate_Field table attributes:
| Attribute | Definition |
|---|---|
| PredicateID | Uniquely identifies the predicate. |
| RelationKey |
|
| FieldID | Unique identifier for the column. |