A

Admin • 802.91K Points
Coach

Q. Which statement is used to force the optimizer to use tables in a particular order?

  • (A) FORCE INDEX
  • (B) -wild
  • (C) IGNORE INDEX
  • (D) STRAIGHT_JOIN
  • Correct Answer - Option(D)
  • Views: 4
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin
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!

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.