Restituisci
-
Titolo
How to create an explain plan with Sql Optimizer on select from session table -
Descrizione
How do you create an explain plan with a select, containing a global temporary table?
If you launch only the select request, SQL Optimizer will say that the session table does not exist. -
Risoluzione
Go to: Tools | User Define Temp Table:
Enter the create and insert statement and press executeNow you can optimize a SQL with a temp table.