René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback

Sorts [Oracle SQL]

Operations requiring sorts:
  • create index
  • sort merge operations
    Because no index is available
  • order by
  • group by
  • select distinct
  • union
  • intersect
  • minus
  • analyze
  • crating a primary key constraint
  • enabling a constraint
  • create table as select
  • create table (if minextents is > 1)
If the sort cannot complete in memory, a temporary segment will be used.