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.