Microsoft SQL Server 2008 Bible
|
|
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. |
|
|