Indexes
All primary and foreign key columns in ACME are indexed. All indexes are prefixed with IDX.Note | Indexes on the foreign keys are unnecessary and even ineffective for a database of this size, but we created them anyway, as if we are working with a huge database with thousands of customers and millions of orders. |