Re: [sqlite] Is it using an index?

2009-04-07 Thread John Machin
On 7/04/2009 6:43 AM, Scott Baker wrote: [snip] > I must have typod and not noticed. Your hypothesis carries within itself the seed of its own plausibility :-) ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Is it using an index?

2009-04-06 Thread Scott Baker
Gerry Snyder wrote: > Scott Baker wrote: >> I didn't realize "INTEGER PRIMARY KEY" was case sensitive. Thanks > > Are you sure what you used before did not have a typo, or the words in a > different order? Good question... must have been. Testing it: sqlite> CREATE TABLE foo (bar integer

Re: [sqlite] Is it using an index?

2009-04-06 Thread P Kishor
On Mon, Apr 6, 2009 at 3:11 PM, Scott Baker wrote: > Eric Minbiole wrote: >>> If I have a query: >>> >>> SELECT foo FROM bar WHERE id = 14; >>> >>> How can I see if that query is optimized to use an index, and which index >>> it's using. I thought if you did an EXPLAIN it

Re: [sqlite] Is it using an index?

2009-04-06 Thread Gerry Snyder
Scott Baker wrote: > I didn't realize "INTEGER PRIMARY KEY" was case sensitive. Thanks Are you sure what you used before did not have a typo, or the words in a different order? Gerry ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Is it using an index?

2009-04-06 Thread Scott Baker
Eric Minbiole wrote: >> If I have a query: >> >> SELECT foo FROM bar WHERE id = 14; >> >> How can I see if that query is optimized to use an index, and which index >> it's using. I thought if you did an EXPLAIN it would show that, but I'm not >> seeing it? Maybe it's not really using an index? >

Re: [sqlite] Is it using an index?

2009-04-06 Thread Eric Minbiole
> If I have a query: > > SELECT foo FROM bar WHERE id = 14; > > How can I see if that query is optimized to use an index, and which index > it's using. I thought if you did an EXPLAIN it would show that, but I'm not > seeing it? Maybe it's not really using an index? Use the command "EXPLAIN

[sqlite] Is it using an index?

2009-04-06 Thread Scott Baker
If I have a query: SELECT foo FROM bar WHERE id = 14; How can I see if that query is optimized to use an index, and which index it's using. I thought if you did an EXPLAIN it would show that, but I'm not seeing it? Maybe it's not really using an index? - Scott