Contents Index Use user-estimates sparingly Using the cache to improve performance

ASA SQL User's Guide
  Monitoring and Improving Performance
    Top performance tips

Reduce expensive user-defined functions


Reducing expensive user-defined functions in queries where they have to be executed many times can improve performance.


Contents Index Use user-estimates sparingly Using the cache to improve performance