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
> >
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
icient rewriting tips are appreciated -
since i am a newbie to SQLite.
Thanx in advance
Jon Friis
3 matches
Mail list logo