Business Table (and Entity) Types

•Reference tables: Customers, Products, etc., entities the business references in its interactions. These tables grow relatively slowly, and tend to be well-cached. •“Events” tables: Orders, Payments, Invoices, Customer Interactions. These tables tend to grow fastest, and to dominate query-tuning problems. Sensible queries almost always concern recent business events, with reference to non-event entities.