Griggs, Donald <[EMAIL PROTECTED]>
wrote:
Regarding: "I thought I can create two separate indexes"
I believe sqlite can use at most *one* index per table in a select.
However, you can create *compound* indicies (though all the
restrictions
pointed to by Dr. H still apply)
Compound indexes help for a test of the form " field1='x' AND field2='y'
", but _not_ for one that looks like " field1='x' OR field2='y' ". Think
about it: if you have a phone book with all names sorted by last name
then first name, it will help you find a person named Peter Pan, but it
doesn't help much in finding all people that are either Peters or Pans.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------