GMSC Discussions

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Posts: 28
Registered: ‎11-04-2015

Dynamic geometry



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


Posts: 1,117
Registered: ‎10-18-2015

Re: Dynamic geometry

Hi Lukas,


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.






Stefano Turcato
Presale Engineer
Hexagon Geospatial