sqlite - Query Plans

Not logged in

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

• Contents
• No-Diff
• Text

*** 86,92 ****
  Option 1, on the other hand, has to run both its outer loop and
  its middle loop 3500 times each, resulting in 12 million iterations
  of the middle loop.  Thus in the second scenario, option 2 is
! nearly 2000 times faster than option 2.
  
  So you can see that depending on how the data is structured in the
  table, either query plan 1 or query plan 2 might be better.  How
--- 86,92 ----
  Option 1, on the other hand, has to run both its outer loop and
  its middle loop 3500 times each, resulting in 12 million iterations
  of the middle loop.  Thus in the second scenario, option 2 is
! nearly 2000 times faster than option 1.
  
  So you can see that depending on how the data is structured in the
  table, either query plan 1 or query plan 2 might be better.  How