empfolene Indices

[Obv]

versuch es doch so

CREATE TABLE MQT2          
AS (
select statement
) DATA INITIALLY IMMEDIATE  REFRESH DEFERRED  
ENABLE QUERY OPTIMIZATION MAINTAINED BY USER

...
 
 
 refresh table MQT2

...

SELECT Sp1, ... FROM  MQT2 WHERE ... GROUP BY Sp1 ...