Henry uses a large database to generate reports and would like to make report delivery more efficient (faster). The reports derive from the following tables.
?
CANDY table, with these columns: PROD_ID, NAME, UNITS_SOLD_LAST_30DAYS
EMPLOYEE table, with these columns: EMP_ID, FIRST_NAME, LAST_NAME, OFFICE_PHONE
?
Write SQL commands to improve the efficiency of creating these two reports:
.Employee records alphabetized by last name, then first name
.Names of candy products listed by units sold in the last 30 days, in descending order

Question

Quizplus · Accepted Answer

The Answer is CREATE INDEX EMPLOYEE_NAME_IND ON EMPLOYEE (LAST_NAME, FIRST_NAME);

CREATE INDEX CANDY_SALES_IND ON CANDY(UNITS_SOLD_LAST_30DAYS DESC)

Henry Uses a Large Database to Generate Reports and Would