DB2数据库物化视图之MQT物化查询表的正确应用
复制CONNECT TO SAMPLE ... ALTER TABLE EMPLOYEE ADD UNIQUE (EMPNO) ALTER TABLE DEPARTMENT ADD UNIQUE (DEPTNO) CREATE TABLE EMP AS (SELECT E.EMPNO,数据 E.FIRSTNME, E.LASTNAME, E.PHONENO, D.DEPTNO, SUBSTR(D.DEPTNAME, 1, 12) AS DEPARTMENT, D.MGRNO FROM EMPLOYEE E, DEPARTMENT D WHERE E.WORKDEPT = D.DEPTNO) DATA INITIALLY DEFERRED REFRESH IMMEDIATE SET INTEGRITY FOR EMP IMMEDIATE CHECKED NOT INCREMENTAL 1.2.3.4.5.6.7.8.9.
本文地址：http://www.bhae.cn/news/014d5899927.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。