Loading ...
Sorry, an error occurred while loading the content.

Added Plan output to AutoTrace in QSP

Expand Messages
  • toadman
    First, what would anyone think of changing the name of the executable to qsp.exe? QSP (QuestSqlPlus) already supported SET AUTOTRACE ON but bow also supports
    Message 1 of 1 , Sep 1, 2002
    • 0 Attachment
      First, what would anyone think of changing the name of the executable to qsp.exe? 
       
       
      QSP (QuestSqlPlus) already supported SET AUTOTRACE ON
      but bow also supports SET AUTOTRACE ON EXPLAIN
       
      The output appears as:
       
      set autotrace on explain
      select * from forma where year is not null
      0 rows selected
       
       
      Statistics
      -----------------------------------------------------------
                0 recursive calls
               96 db block gets
                0 consistent gets
                0 physical reads
                0 redo size
             1833 bytes sent via SQL*Net to client
              744 bytes received via SQL*Net from client
                4 SQL*Net roundtrips to/from client
                2 sorts (memory)
                0 sorts (disk)
       
      1     SELECT STATEMENT Hint=CHOOSE(Cost=92, Card=1 K, Bytes=570 K)
      2       PARTITION RANGE ALL
      3         PARTITION HASH ALL
      4           TABLE ACCESS FULL OF 'FORMA'
    Your message has been successfully submitted and would be delivered to recipients shortly.