CREATE UNIQUE INDEX TYPE.OPERATION_IDX1T
  ON TYPE.OPERATION
    ( ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;

WITH MONITOR_SELECT
(IS_EDITABLE,QUANTITY,DATE,BOOK_DATE) 
AS (
SELECT 
case when coalesce(t1.BOOK_DATE, t1.DATE) >  date('2013-02-28')
	then 'Y'
	else	'N'
	end,
t1.QUANTITY,
t1.DATE,
t1.BOOK_DATE
FROM
 TRANSACTION.LIABILITY_SDEPO t1 
	left  join DOCUMENT.DOC_OPERATION t2 on t1.ID_DOC_OPERATION = t2.ID
	left  join TYPE.OPERATION t21 on t21.ID = t2.ID_OPERATION
WHERE (
 t1.ID_PERSON_FUND = 99 and t1.IS_PLANNED = 'N' and 
(
	t1.DATE <= date('2013-03-27')
	or 
	t1.BOOK_DATE <= date('2013-03-27')
) 
)) 
SELECT IS_EDITABLE,QUANTITY,DATE,BOOK_DATE
FROM MONITOR_SELECT WITH UR

create table mqt1 as (select ... from nick1)
data initially deferred refresh deferred maintained by user;
set integrity for mqt1 materialized query immediate unchecked;
create unique index mqt1_u on mqt1 (...);

truncate table mqt1 immediate;
insert into fed.tables_mqt select * from nick1;
runstats on table schema.mqt1 ...;