Changes

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.

* MYSQL5 MySQL5 has a process to optimize queries that in some cases actually reduces the performance. This is a known issue with MYSQL5MySQL5. * Enabling the straight join prevents MYSQL MySQL from trying to optimize the query and runs it exactly as provided by the system.