Select to view content in your preferred language

Spatial Index on Materialized View

842
0
03-22-2016 09:00 AM
Status: Open
Labels (1)
LiwenBao
New Contributor II

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