9 Performance Best Practices

Unnecessarily complex data sets can result in poor performance of data model execution. This chapter provides tips for creating more efficient data models.

• Know Oracle WebLogic Server Default Time Out Setting

• Best Practices for SQL Data Sets

• Limit Lists of Values

• Working with Lexicals/Flexfields

• Working with Date Parameters

• Run Report Online/Offline (Schedule)

• Setting Data Model Properties to Prevent Memory Errors

• SQL Query Tuning