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

Copyright© 2018 HCL Technologies Limited