Ordering the joins

The order of your table joins can impact performance. Although the optimal order depends on the report, the key iMIS joins are:

Name.ID = Activity.ID
Name.ID = Subscription.ID
Name.ID = Invoice.BT_ID
Orders.ORDER_NUMBER = Order_Lines.ORDER_NUMBER
Product.PRODUCT_CODE = Order_Lines.PRODUCT_CODE
Name.ID = Orders.BT_ID