ELIMINATE_DUPLICATES
about the size of the
merge runs. This value
will be NULL for an
internal sort.
whether or not this sort
eliminated duplicates
from the input. Valid
values are 'Y' and
'N'. This column
only applies for a
sort which was NOT
performing GROUP
BY aggregation; for
GROUP BY sorts this
column is always NULL.
See the DISTINCT_AGGREGATE
column for the
corresponding
information for
aggregating sorts.
whether or not the rows
which were input to the
sorter were already in
sort order, which can
happen if the rows were
retrieved by using an
index, or if an earlier
phase of processing
had already sorted the
data. The code is 'Y' if
the rows are already
in sorted order, and 'N'
otherwise.
whether the
aggregation process
was computing distinct
aggregates or not. Valid
values are 'Y' and 'N'.