Suppose I have two tables, and I want to have look for a value in the first
table, but display the columns from the second table. The most obvious way
would be joining them on rowid. But I don't need to SELECT any columns from
the first table, and it's a FTS4 table (which always joins a bit slower
On Fri, Nov 11, 2011 at 11:58 AM, Petite Abeille
petite.abei...@gmail.com wrote:
It returns the same results, but it doesn't seem much faster. Is there any
performance difference to be expected from using IN instead of JOIN, or
does SQLite internally rewrite JOIN queries to something similar as
On Nov 12, 2011, at 1:58 AM, Pavel Ivanov wrote:
No, exists in this case will change query plan significantly and
performance can degrade drastically as a result.
Why would that be?
___
sqlite-users mailing list
sqlite-users@sqlite.org
Fabian wrote:
Suppose I have two tables, and I want to have look for a value in the first
table, but display the columns from the second table. The most obvious way
would be joining them on rowid. But I don't need to SELECT any columns from
the first table, and it's a FTS4 table (which always
On Fri, Nov 11, 2011 at 8:06 PM, Petite Abeille
petite.abei...@gmail.com wrote:
No, exists in this case will change query plan significantly and
performance can degrade drastically as a result.
Why would that be?
How would you rewrite the query using exists? The only thing I have in mind is