Best Practices for Using Materialized Views in HP Neoview Release 2.4 (R2.4, R2.4 SP1, R2.5)

22
The INSERT and DELETE privileges on an MV can be granted by the MV’s creator or any user that has
a grant option. INSERT and UPDATE commands are blocked on MVs. The DELETE command on
RECOMPUTED and ON STATEMENT MVs is blocked. The DELETE privilege on ON REQUEST MV
enables the user to perform deletes.
Limitations
Materialized Views in Neoview Release 2.4 have these limitations:
• A regular view that uses an MV is never updateable.
• Incremental MVS (MVs that are not RECOMPUTE) currently cannot use regular views.
© 200
9
Hewlett
-
Packard
Development Company, L.P. The information contained
herein is subject to change without notice. The only warranties for HP products and
services are set forth in the express warranty statements accompanying such
products and services. Nothing herein should be construed as constituting an
additional warranty. HP shall not be liable for technical or editorial errors or
omissions contained herein.
Itanium is a trademark or registered trademark of Intel Corporation in the U.S. and
other countries and is used under license.
598392-001