Nice
ok
and can we control which columns from explain plan should be displayed in this command window? In a SQL Window, we can press the Settings button and add what information we want.. but in the explain plan above, how can control which information to appear?
One more thing, to the developer: it would great if we would have a parameter, which we set to ON, and after issuing a query, the query plan is automatically displayed (without we issuing "select * from table (......."
And also, why AUTOTRACE cannot be set in PL/SQL Developer, like in the following example (SQL*Plus):
[quote]
SQL> set autotrace on
SQL> select * from dual;
D
-
X
Execution Plan
----------------------------------------------------------
Plan hash value: 272002086
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |
--------------------------------------------------------------------------
Statistics
----------------------------------------------------------
5 recursive calls
0 db block gets
5 consistent gets
3 physical reads
0 redo size
331 bytes sent via SQL*Net to client
337 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
SQL> set autotrace off [/quote]
In PL/SQL Developer we get "Cannot set AUTOTRACE"
Thanks.