syssqltrace_iter
The syssqltrace_iter table lists the SQL statement iterators.
| Column | Type | Description |
|---|---|---|
| sql_id | int8 | SQL execution ID |
| sql_address | int8 | Address of the SQL statement block |
| sql_itr_address | int8 | Address of the iterator |
| sql_itr_id | int | Iterator ID |
| sql_itr_left | int | Iterator ID to the left |
| sql_itr_right | int | Iterator ID to the right |
| sql_itr_cost | int | Iterator cost |
| sql_itr_estrows | int | Iterator estimated rows |
| sql_itr_numrows | int | Iterator actual rows processed |
| sql_itr_type | int | Iterator type |
| sql_itr_misc | int | Iterator miscellaneous flags |
| sql_it_info | char(256) | Iterator miscellaneous flags displayed as text |