Does anyone have an example of using Scalar Subquery Caching with SDO_GEOMETRY to improve query/function performance?
Scalar Subquery Caching
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.