What causing QUEST_TEMP_Explain to create, if CREATE/Describe/Declare commands are not used to Statement

Toad Data Point
1

Recently we have noticed Global Temp Table " .QUEST_TEMP_EXPLAIN" was created while connection to Database using Toad. Wondering what cause this table to create as I didn’t define any CREATE/DECLARE/Describe statement in my SQL Query. I am just running simple Select statement in my query.

2

This is a temp table the app makes so that explain plans can be generated. if you would rather use a different table you can point to it in the connection window.

3

Hi Debbie,

Thanks for the response. Wondering if we know which app makes this table, even though there is no argument for Create table passed in SQL Query Statement. Is the Toad application creating this automatically?

4

Yes, Toad Data Point is making this temp table.