8,849
edits
Changes
no edit summary
It is best practice to build reports with those attributes both with Straight Join enabled, and then disable Straight Join to evaluate which option has a faster response when viewing the report.
'''Technical Details:'''
* MySQL5 has a process to optimize queries that in some cases actually reduces the performance. This is a known issue with MySQL5.
* Enabling the straight join prevents MySQL from trying to optimize the query and runs it exactly as provided by the system.