I could find QUEST_TEMP_EXPLAIN global temporary table in my schema. Would like to know when and how does it get created? Also when this table will be dropped?
The table is created before generating explain plan and it’s not persistent. When the connection closes the table is dropped automatically.