Identify patterns on the architecture dashboard that can result in slow queries.  Some I have found:

• When comparing date time, adjusting the date time of an entity is slower than adjusting a static date time
• Creating calculated fields on other calculated fields
• CROSS Join vs Other Joins