第34次：2014-10-13

botang

1. declare
   
2.   v_1  varchar2(200);
   
3. begin
   
4. 
   
5. dbms_advisor.tune_mview(
   
6.      v_1,
   
7.    
   
8.    'CREATE MATERIALIZED VIEW cust_sales_mv
   
9.    BUILD IMMEDIATE
   
10.    REFRESH FAST ON COMMIT
    
11.    ENABLE QUERY REWRITE
    
12.    AS SELECT c.cust_id,
    
13.           SUM(amount_sold) AS dollar_sales
    
14.    FROM SALES s, CUSTOMERS c
    
15.    WHERE  s.cust_id=c.cust_id
    
16.    GROUP  BY c.cust_id'
    
17. 
    
18.     );
    
19. end;
    
20. /
    
21. 
    
22. select  to_char(statement)   from user_tune_mview;
    

复制代码