Visualizing Data in Oracle Analytics Server Reference Design Tips 26 Design Tips This chapter contains reference information to help you build visualizations and reports. Topics: Find the SQL_ID for an Oracle Analytics Query Use the IndexCol Function Use Usage Tracking with Initialization Blocks Minimize Impact on Query Performance Due to Network Latency Assign the Aggregation Rule for Report Totals Select the Best Option to Render Dashboards Improve the Time to Display Dashboard Pages with Prompts Configure Timestamps Use Filter Functions Instead of Time Series Functions Tune Performance of Multidimensional Database Queries Tune Performance of Relational Database Queries Tune Performance with Excluded Columns