following up on my own response to Dan…
I see what you mean Dan. I am not an expert at reading the query plans, but I
do see that effectively my new query has the same query plan as the last two
queries combined as well as the original query. The only difference is the
order in which it
> On Mar 9, 2020, at 1:04 PM, Dan Kennedy wrote:
>
>
> On 9/3/63 01:44, Puneet Kishor wrote:
>> Update: so, after much hitting of my head against the wall of sql, I came up
>> with the following – as noted above, I really have two distinct set of
>> queries I can do separately like so
>>
On 9/3/63 01:44, Puneet Kishor wrote:
Update: so, after much hitting of my head against the wall of sql, I came up
with the following – as noted above, I really have two distinct set of queries
I can do separately like so
Q1: (SELECT t1Id FROM t1 WHERE …) AS a
Q2: (SELECT t1Id FROM vt1
Update: so, after much hitting of my head against the wall of sql, I came up
with the following – as noted above, I really have two distinct set of queries
I can do separately like so
Q1: (SELECT t1Id FROM t1 WHERE …) AS a
Q2: (SELECT t1Id FROM vt1 WHERE vt1 MATCH ‘bar’) AS b
Then, I can do
On 7/3/63 14:58, P Kishor wrote:
I asked this question on Stackoverflow with not much success, and a suggestion
to ask it on the list. So here I am. I have two tables, t1(id, t1Id, … other
cols …, fullText) and a FTS5 virtual table vt1(t1Id, fullText)
```
sqlite> EXPLAIN QUERY PLAN
...>
5 matches
Mail list logo