Spatial Index on Materialized View

Idea created by baol on Mar 22, 2016
    New
    Score10
    • baol
    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