global temp table
RELY constraints, even though they are not used for data validation, can:- Enable more sophisticated query rewrites for materialized views. See Chapter 22, "Query Rewrite" for further details.
- Enable other data warehousing tools to retrieve information regarding constraints directly from the Oracle data dictionary.
Creating a
RELY constraint is inexpensive and does not impose any overhead during DML or load. Because the constraint is not being validated, no data processing is necessary to create it.
No comments:
Post a Comment