31 Design Tips

This chapter contains reference information to help you build visualizations and reports.

Topics:

• Find the SQL_ID for an Oracle Analytics Query

• IndexCol Function

• Initialization Block Maintenance

• Initialization Blocks and Usage Tracking

• Minimize Impact on Query Performance Due to Network Latency

• Report Totals

• Select the Best Option to Render Dashboards

• Select Prompts before Opening for Faster Dashboards

• Timestamps

• Time Series

• Tune Performance of Multidimensional Database Queries

• Tune Performance of Relational Database Queries

• Tune Performance with Excluded Columns