Hi Richard,
Why would you not want to index the NumEmployees and Discount Rate fields in this Customer Table, too? (conceptually)

---

Reply from Richard Rost:

You could if you want to. If you're going to be generating lots of reports that sort on these fields, use them as criteria, or you're going to be searching for these values, you certainly could.

Indexing makes your database bigger, and SLOWS DOWN updates, whereas it SPEEDS UP lookups. So you want to find the right balance for your database. Don't index EVERYTHING, but definitely index the fields you use a lot.