1.

What Are The Operations Required In Temporary Segments?

Answer»

The following commands may require the use of a temporary segment:

  • CREATE INDEX
  • SELECT ... ORDER BY
  • SELECT DISTINCT ...
  • SELECT ... GROUP BY
  • SELECT ... UNION
  • SELECT ... INTERSECT
  • SELECT ... MINUS
  • unindexed JOINS
  • certain CORRELATED subqueries

The following commands may require the use of a temporary segment:



Discussion

No Comment Found