Consider the following query against the MVCH database:

For each treatment ordered in the past two weeks, list by treatment ID and date (in reverse chronological order) the number of times a physician performed that treatment that day, sorted alphabetically by physician name.

a. Which secondary key indexes would you suggest to optimize the performance of this query? Why? Make any assumptions you need in order to answer this question.

b. Following the examples in this chapter, write the SQL statements that create these secondary key indexes.