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. |