sql - SQLite and range query

Question

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?

Answer 1

SQLite's documentation for the R-tree module says:

An R-Tree is a special index that is designed for doing range queries.