SQLite Forum

Views with UNION ALL
Thank you.  That makes sense.  I guess the question is how reliable SQLite is in being able to estimate what would be faster.  I thought it would always be faster to cache the results of the view, but I guess not.  I will look at the documentation on EXPLAIN and see what I can make of it.  Thanks again.