
102 4.4 Analyzing and Managing Materialized Views
4.3.5 Materialized View ORDER BY Clauses
A materialized view creation query can contain an ORDER BY clause. The
ORDER BY clause will help to physically sequence data. However, materi-
alized views are maintained by underlying tables, and underlying tables are
not necessarily sorted in the sequence of the ORDER BY clause. Also, the
materialized view ORDER BY clause sort order is not used during refresh.
It should suffice to state that if the materialized view initial creation
ORDER BY clause matches sorting requirements when queries execute
query rewrite operations through the materialized view, that ORDER ...