Delay in creating materialized view
Hi,
I'm trying to create the following materialized view:
CREATE MATERIALIZED VIEW p.vmiew1
BUILD IMMEDIATELY
USING INDEX
REFRESH FORCE ON DEMAND
USING TRUSTED CONSTRAINTS
TO THE
SELECT hc.cod,
hc.sit,
hc.sgl,
hc.sec
FROM hist@dblnk hc
JOIN m@dblnk m on m.cod = hc.cod_m
WHERE hc.sgl like 'XX'
AND m.cod_dat IN (SELECT cod_dat FROM pleito_config WHERE flag=1) ;
But it's taking too long.
But if I just execute the select command, the response doesn't take long. What can it be?