Pinned topic Temporal and EXPLAIN
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
The implementation of temporal tables uses a separate history table to store historical rows. This history table is an actual DB2 table, so whenever a statement is going through an EXPLAIN, the history table will be shown in the EXPLAIN output just like any other table.