On Thu, Jan 10, 2013 at 10:31 AM, Jonathan Moules <[email protected]> wrote: > Hi Christian, > Wow, that's fast for 19million features, but at that speed I'd assume it has > the bounds pre-calculated; its probably getting them from > MDSYS.USER_SDO_GEOM_METADATA or similar, but I don't know how Oracle 11 does > things. > It seems like Oracle 11 is better at data integrity and maintaining its > spatial metadata than 10.
Hi Jonathan, SDO_TUNE.EXTENT_OF should use the spatial index of your table. The spatial index root contains the bounding box of all geometries in the column, that's why it fast, no need to calculate anything. -- == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Davide Savazzi @svzdvd Senior Software Engineer GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
