@ WithBridgeMethods ( value = MySQLQuery . class , castRequired = true ) public C straightJoin ( ) { return addFlag ( Position . AFTER_SELECT , STRAIGHT_JOIN ) ; }
STRAIGHT_JOIN forces the optimizer to join the tables in the order in which they are listed in the FROM clause . You can use this to speed up a query if the optimizer joins the tables in nonoptimal order . STRAIGHT_JOIN also can be used in the table_references list .