sqlite - Query Plans

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 197,199 ****
--- 197,207 ----
  associative or commutative.  Reordering tables in outer joins changes
  the result.)  The use of the CROSS keyword to disable the table
  reordering by the optimizer is a planned feature for SQLite 3.2.6.
+ 
+ 
+ ----
+ 
+ Postgresql apparently uses the same trick (of explicit CROSS JOIN)
+ to disable table reordering.
+ See
+ http://www.postgresql.org/docs/7.1/interactive/explicit-joins.html