04-28-2016 02:38 AM
we don't have geometry stored in DB, we cannot have it stored due to other issues. But we have information that can create geometry dynamically. Somethig like select CreateGeometry(TABLEA.X, TABLEB.Y) as geometry from dual In this case, we do not have spatial index. Is there any chance how to display it in GMSC? Materialized view doesn't meet the performace requirements.
thx a lot
04-28-2016 02:56 AM
there is no way to display a geometry without a spatial index efficiently. I don't get the point about materialized view: it should help a lot in terms of performance because it is like a dynamic table. By the way as far as I remember you cannot create an fast refreshable materialized view with a SDO_GEOMETRY column, so you must basically update it on your own using a dedicated mechanism.