VSQL_PLAN_STATISTICS provides execution statistics at the row source level for each child cursor.
The parameter STATISTICS_LEVEL must be set to ALL in order to see data in this view.
| Join Column Equality Predicate | Join Table | In order to add |
|---|---|---|
| ADDRESS and HASH_VALUE | VSQLAREA | cursor-specific information |
| ADDRESS, HASH_VALUE, and CHILD_NUMBER | VSQL | child cursor-specific information |