It is normal to see an extra sort in the autotrace statistics. The query on the
PLAN_TABLE that is used to display the execution plan has an ORDER BY clause.
There can be two such sorts if the OTHER_TAG column in the execution plan is not
entirely null.


-----Original Message-----
Sent: Friday, 1 September 2000 22:09


Autotrace shows that there are sorts, but there are no recursive calls. My query
is a simple select without any order by clause, group by clause, distinct and so
on. What does Oracle sort?

Execution Plan
----------------------------------------------------------
  0      SELECT STATEMENT Optimizer=CHOOSE (Cost=1 Card=1 Bytes=6)
  1    0   TABLE ACCESS (FULL) OF 'TAX_VALUES' (Cost=1 Card=1 Bytes=6)

Statistics
----------------------------------------------------------
          0  recursive calls
          4  db block gets
          2  consistent gets
          0  physical reads
          0  redo size
        596  bytes sent via SQL*Net to client
        553  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
          2  sorts (memory)
          0  sorts (disk)
          1  rows processed