Re: [sqlite] Odd query optimization

2005-12-02 Thread Kurt Welgehausen
> Anyone have any thoughts ... ? You've already figured it out. For more info, see . Regards

[sqlite] Odd query optimization

2005-12-02 Thread Paul Bohme
OK, little puzzled by this one, wondering if my expectations of behavior are off. (Apologies for the longish post..) This is with 3.2.7. I have a reasonably simple 'users' table, with a single compound index (at first) on user last/first name: create table users ( id integer primary key,