Thanks for explaining the concept of INDEXING and how such decisions may not affect a database with hundreds of records, but does with thousands of records. And the potential effects of accessing a database over a network. All good tips that the student won't have to learn the hard way.

---

Reply from Richard Rost:

Thanks. You don't realize it when you first start working with databases, but as your db grows from a few hundred to a few hundred THOUSAND records, you'll see the benefits of indexing properly the first time you have to wait 3 minutes for a report to load. :)