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.