Q. Which statement is used to force the optimizer to use tables in a particular order?
β
Correct Answer: (D)
STRAIGHT_JOIN
Explanation: This question asks about how to control the way MySQL chooses to read data from your tables when you run a query. MySQL has a smart "optimizer" that tries to figure out the fastest way to get the information you want. Sometimes, you need to give it a little help!