This topic has been locked.
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.