Difference between revisions of "What does the straight join option do?"
From SmartWiki
m |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | '''Q: What does the [ | + | '''Q: What does the [[Straight Join]] option do? |
''A: In mySQL there is a query optimizer. In a few cases the optimizer puts the queries in the wrong order, so the [http://dev.mysql.com/doc/refman/5.0/en/join.html straight join] option will processes the queries sequentially and may improve report performance. If adding the straight join option does not improve report performance, it can be left unchecked. | ''A: In mySQL there is a query optimizer. In a few cases the optimizer puts the queries in the wrong order, so the [http://dev.mysql.com/doc/refman/5.0/en/join.html straight join] option will processes the queries sequentially and may improve report performance. If adding the straight join option does not improve report performance, it can be left unchecked. | ||
| + | |||
| + | ==See Also== | ||
| + | * [[Straight Join]] | ||
| + | * [[Edit Report Page: Advanced Settings Tab]] | ||
[[Category:Reports]][[Category:FAQ]] | [[Category:Reports]][[Category:FAQ]] | ||
Latest revision as of 10:21, 30 April 2013
Q: What does the Straight Join option do?
A: In mySQL there is a query optimizer. In a few cases the optimizer puts the queries in the wrong order, so the straight join option will processes the queries sequentially and may improve report performance. If adding the straight join option does not improve report performance, it can be left unchecked.
