How could I perform a simple range query in SQLite efficiently?
Say, I have data that saves a person information and I want to find the people with age between 20~45, and weight between 50~80kg?
What should I do (like setting certain index?) to make the searching more efficient?
See Question&Answers more detail:os