subject:"\[sqlite\] How can i see if an query uses an index \?"

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

2006-01-31 Thread Dennis Cote

Jon Friis wrote: Hi all I have the following table + index CREATE TABLE O_YDLRK_CK91_HIST ( ISIN TEXT NULL, BOERS_DATODATE NOT NULL, TERM_DATO DATE NOT NULL, AFDRAG_BELOEB REAL NULL, RENTE_BELOEB REAL NULL, CONSTRAINT

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

2006-01-30 Thread Jon Friis

Hi all I have the following table + index CREATE TABLE O_YDLRK_CK91_HIST ( ISIN TEXT NULL, BOERS_DATODATE NOT NULL, TERM_DATO DATE NOT NULL, AFDRAG_BELOEB REAL NULL, RENTE_BELOEB REAL NULL, CONSTRAINT