Tag Info

New answers tagged


The spatial aggregate operations tend to be expensive, especially those that go above and beyond the simple MBR calculation (aggregate union, aggregate convex hull, aggregate. They have been massively improved in 12c through the Vector Performance Acceleration mechanism of Oracle Spatial. The MBR aggregation is simpler, but still needs to do a lot of work, ...


Based on the SQL present in your query, you may want to change the spatial function you're using. In the past, the SDO_TUNE.EXTENT_OF('TABLE_NAME', 'SPATIAL_COLUMN') has given us better performance and, according to the below link (assuming the documentation has been kept up-to-date), that is the proper way to get the MBR for a table in the specified ...

Top 50 recent answers are included