- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Scalar Subquery Caching
Does anyone have an example of using Scalar Subquery Caching with SDO_GEOMETRY to improve query/function performance?
Rewriting the function call into a scalar subquery allows Oracle to use scalar subquery caching to optimize the number of function calls needed to complete the query. Oracle builds an in-memory hash table to cache the results of scalar subqueries.
SELECT (SELECT slow_function(id) FROM dual) FROM func_test;
I've been reading about Scalar Subquery Caching, but I'm not sure how it might apply to spatial queries.