On Sun, Jun 15, 2014 at 12:25 AM, Eric Rubin-Smith <eas....@gmail.com> wrote:
> > sqlite> explain query plan SELECT prefix, target FROM routeTarget WHERE id > = ( > ...> SELECT id FROM ipIndex > ...> WHERE minD1 <= 1220818432 and 1220818432 <= maxD1 > ...> AND minD2 <= 2120561472 and 2120561472 <= maxD2 > ...> AND minD3 <= 1685398080 and 1685398080 <= maxD3 > ...> AND minD4 <= 1685755328 and 1685755328 <= maxD4 > ...> AND minD5 <= 538331072 and 538331072 <= maxD5 > ...> ORDER BY ((maxD5-minD5)*(maxD4-minD4)*(maxD3-minD3)* > ...> (maxD2-minD2)*(maxD1-minD1)) ASC > ...> LIMIT 1); > 0|0|0|SEARCH TABLE routeTarget USING INTEGER PRIMARY KEY (rowid=?) > 0|0|0|EXECUTE SCALAR SUBQUERY 1 > 1|0|0|SCAN TABLE ipIndex VIRTUAL TABLE INDEX 2:B0D1B2D3B4D5B6D7B8D9 > 1|0|0|USE TEMP B-TREE FOR ORDER BY > What does this query return? SELECT count(*) FROM ipIndex WHERE minD1 <= 1220818432 and 1220818432 <= maxD1 AND minD2 <= 2120561472 and 2120561472 <= maxD2 AND minD3 <= 1685398080 and 1685398080 <= maxD3 AND minD4 <= 1685755328 and 1685755328 <= maxD4 AND minD5 <= 538331072 and 538331072 <= maxD5; -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users