πŸ“Š MySQL
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
πŸ’¬ Discuss
βœ… 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!

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

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
80
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Ravi Shankar
Publisher
πŸ“ˆ
96%
Success Rate