Figuer: -What Programmer's or User's Decision Typically Will Affect the Performance

Multiple Choice

Figuer:
-What programmer's or user's decision typically will affect the performance of the query?

A) Placing the condition "PICKUP = 'ERIE' OR PICKUP = 'CARY'" before the condition "CUSTOMER.CID = RENTALS.CID" in the query.
B) Placing the condition "PICKUP = 'ERIE' OR PICKUP = 'CARY'" after the condition "CUSTOMER.CID = RENTALS.CID" and before the condition "RENTALS.MAKE = RENTCOST.MAKE" in the query.
C) Selecting the attributes CID in CUSTOMERS and CID in RENTALS as indexes on the tables.
D) None of the above