Both active and non-active queries are subject to some best practices in Oracle BAM 12c.
For optimal performance of your business queries, Oracle recommends the following best practices.
For tactical (non-active), queries, examine the query string generated by the business query and run the DB AWR report to tune the index or change your query to improve performance.
For an active query, always specify a window size (range) because these will reduce amount of memory required. Also, use the output window (sliding) judiciously to collapse results and so as to not overwhelm the dashboards.
Use the aggregation query and bind it to a chart. Then perform drill down to detail records. This organizes the data into smaller chunks and improves performance.
Test your query with your production data set to ensure that the performance is reasonable.
Familiarize yourself with the differences between scheduled query and realtime active query and use them as appropriate.