Re: [sqlite] Scan table in explain query. Question.

2013-05-11 Thread Clemens Ladisch
Staffan Tylen wrote: > SEARCH USING COVERING INDEX > SEARCH USING INDEX > SCAN USING COVERING INDEX > > What is the difference and what do they imply? Full table scans, index lookups (searches), and covering indices are explained on this page: . Regards,

Re: [sqlite] Scan table in explain query. Question.

2013-05-11 Thread Staffan Tylen
sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun...@sqlite.org] On Behalf Of Paolo Bolzoni > > Sent: Saturday, 11 May, 2013 09:17 > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] Scan table in explain query. Question. > > >

Re: [sqlite] Scan table in explain query. Question.

2013-05-11 Thread Keith Medcalf
tml e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Paolo Bolzoni > Sent: Saturday, 11 May, 2013 09:17 > To: General Discussion of SQLite Database > Subject: Re: [sqlite]

Re: [sqlite] Scan table in explain query. Question.

2013-05-11 Thread Paolo Bolzoni
At the moment EXPLAIN gives me a very small number of rows for all the queries (thanks to indexes) a part of this one, so if I understand correctly ANALYZE is not needed anymore. Or I can get a speed up executing once in a while? Regards, Paolo On Sat, May 11, 2013 at 1:06 PM, Clemens Ladisch

Re: [sqlite] Scan table in explain query. Question.

2013-05-11 Thread Clemens Ladisch
Paolo Bolzoni wrote: > sqlite> explain query plan SELECT id FROM tour LIMIT 1; > 0|0|0|SCAN TABLE tour USING COVERING INDEX tour_unsorted_path_idx > (~100 rows) > > I am not still sure I understand completely the output of explain > query

Re: [sqlite] Scan table in explain query. Question.

2013-05-11 Thread Simon Slavin
On 11 May 2013, at 10:23am, Paolo Bolzoni wrote: > sqlite> explain query plan SELECT id FROM tour LIMIT 1; > 0|0|0|SCAN TABLE tour USING COVERING INDEX tour_unsorted_path_idx >(~100 rows) > > I am not still

[sqlite] Scan table in explain query. Question.

2013-05-11 Thread Paolo Bolzoni
sqlite> explain query plan SELECT id FROM tour LIMIT 1; 0|0|0|SCAN TABLE tour USING COVERING INDEX tour_unsorted_path_idx (~100 rows) I am not still sure I understand completely the output of explain query plan. But for sure, a small number