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.