On Sun, Jun 15, 2014 at 12:25 AM, Eric Rubin-Smith <[email protected]>
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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
