by Markus Winand.
SQLite offers two different levels of execution plans: (1) the machine code for the virtual machine; (2) the high level query plan.
This tutorial shows the second variant only.
You can prefix any arbitrary SQL command by explain query plan to retrieve the query plan (instead of running the query).
EXPLAIN QUERY PLAN
SELECT RANDOM()This minimalistic example returns the following execution plan:
QUERY PLAN
`--SCAN CONSTANT ROWYou can’t learn everything in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up. Have a look at modern-sql.com as well.
Markus Winand provides insights into SQL and shows how different systems support it at modern-sql.com. Previously he made use-the-index-luke.com, which is still actively maintained. Markus can be hired as trainer, speaker and consultant via winand.at.
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »