> Specifically, when I said "using directly the select of the view", I mean
> execute this query:
>
> EXPLAIN QUERY PLAN SELECT wg.*, count(DISTINCT w.idWord) AS itemsCount,
> count(DISTINCT dw.Document_idDocument) AS documentsCount
>
> FROM WordGroup wg
> LEFT OUTER JOIN Word w ON
Hello Pavel,
Thank you for your answer.
Probably, as you have commented, the problem is that the optimizer of
SQLite does not work fine in this case.
Specifically, when I said "using directly the select of the view", I
mean execute this query:
EXPLAIN QUERY PLAN SELECT wg.*,
> I have been analyzing the Query PLAN. In the query "Select * FROM
> WordGroupView Where idWordGroup = 1;" the database engine perform a scan
> over WordGroup table, and it is not necessary since the where clause is
> defined. However, using directly the query of the view change the SCAN by a
>
Hello,
I am new in this mailing list.
I am developing a Java tool and I use SQLite as file format. At this
moments, I did not have any problem, and SQLite works quite fine.
I want to create some views to generate statistical and aggregate data
in order to show more information to the user.
4 matches
Mail list logo