Hi, I'm using geoserver 2.9.0 with the oracle plugin and try to publish a layer of a view. I created the View in the database and in Geosever (add new layer -> create view) with the same results. The original table in the database has a spatial index and publishing the table directly works fine. If i use any kind of view, the spatial index of the table seems to be ignored. Even the computation of the Bounding Box takes ~30 minutes (with an index ~15 seconds).
Does anyone else have the same problem? Any suggestions how to solve this problem? Creating materialized views for each table is no option for me since i'm running out of table space. Cheers, Max -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-view-doesn-t-usw-spatial-index-tp5278308.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
