Refer to Figure 4-4. For each of the following reports (with sample data), indicate any indexes that
Question:
Refer to Figure 4-4. For each of the following reports (with sample data), indicate any indexes that you feel would help the report run faster as well as the type of index:
a. State, by products (user-specified period)
State, by Products Report, January 1, 2010, to March 31,2010
b. Most frequently sold product finish in a user-specified month
Most Frequently Sold Product Finish Report, March 1, 2010, to March 31, 2010
c. All orders placed last month
Monthly Order Report, March 1, 2010, to March 31, 2010
Associated Order Details:
Associated Order Details:
d. Total products sold, by product line (user-specified period)
Products Sold by Product Line, March 1, 2010, to March 31, 2010
Step by Step Answer:
a An index on the State field of the customer table would help with grouping and ...View the full answer
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
