Re: [sqlite] Interpretation of explain plan

2006-02-15 Thread Jon Friis
Onsdag den 15. februar 2006 18:24 skrev [EMAIL PROTECTED]: > Jon Friis <[EMAIL PROTECTED]> wrote: > > When i execute this on O_YDLRK_CK91_HIST i get the following plan and > > a response time on 0.1 of a sec. > > > > 0|0|TABLE O_YDLRK_CK91_HIST WITH INDEX > >

[sqlite] Interpretation of explain plan

2006-02-15 Thread Jon Friis
HIST|XIE1O_YDLRK_CK91_HIST|4312863 1541 O_YDLRK_CK91_HIST|sqlite_autoindex_O_YDLRK_CK91_HIST_1|4312863 1130 37 1 My question is how come the execution plans differ ? and how should I interpret the explain plans. All help is very welcome, since i have been troubled with this a lot - and the deadline is al

[sqlite] How can i see if an query uses an index ?

2006-01-30 Thread Jon Friis
icient rewriting tips are appreciated - since i am a newbie to SQLite. Thanx in advance Jon Friis