After sharing my previous article, I received an insightful tip from Wilko van der Hoorn: Make your function deterministic for better performance. So I decided to put it to the test.
The results? A clear improvement in query performance!
https://medium.com/@mraoul/boosting-query-performance-with-deterministic-functions-in-oracle-f4d9dbc56690
The results? A clear improvement in query performance!
https://medium.com/@mraoul/boosting-query-performance-with-deterministic-functions-in-oracle-f4d9dbc56690
Comments