Answers to Selected Questions and Problems

31. The query will benefit from having an index on CUS_AREACODE and an index on CUS_CODE. Because CUS_CODE is a foreign key on invoice, it’s likely that an index already exists. In any case, the query uses the CUS_AREACODE in an equality comparison; therefore, an index on this column is highly recommended. The command to create this index ... ................
................