SQLite Index

If you look at SQLite's EXPLAIN output, you sometimes may notice something unusual if you're coming from other SQL databases like PostgreSQL or MySQL.