What does the straight join option do?
From SmartWiki
Revision as of 10:10, 26 January 2011 by Thu (talk | contribs) (Created page with ''''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 opt…')
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.
