The spatial index is not working in materialized view on sdo_geometric type shape field in Oracle 11.2.04. The map rendering is very slow. According to ESRI it was caused by following select statement in map rendering process. I would like the development group to use some other statement instead.
select SDO_AGGR_MBR(SHAPE)
from SDE.TEST_MV x
where x.SHAPE.SDO_GTYPE IS NOT NULL
