SQL Recommendations
• Avoid making unbounded SQLs statements with no boundary condition on date columns.
• Reduce CLOB searches and use physical columns wherever possible.
• Implement caching to pre-fetch data instead of issuing multiple SQLs.
Parent topic