Cesar David Rodas Maldonado
<[EMAIL PROTECTED]> wrote:
How can I optimize this query
select * from table where col1 = 5 && col2 = 15;
If I know that col2 I have 150000 rows and col1 I have just 100
rows, I know that because I save that data in another table.
How can I do for search first where is minus number of result?
The two columns are indexes.
Try making it
select * from table where col1 = 5 and +col2 = 15;
The unary plus in front of col2 disqualifies it for use in an index, so
SQLite is likely to use an index on col1.
Igor Tandetnik