SyntaxPilot
Courses/SQL and Databases/Lesson 64
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

SQL and Databases · Lesson 64 of 90

The query planner: reading EXPLAIN

query optimizerquery plannerexecution planEXPLAINEXPLAIN QUERY PLAN (SQLite)EXPLAIN ANALYZEcost-based optimizationcost estimatecardinality estimationtable statisticsANALYZEsqlite_stat1histogramplan nodes (SCAN, SEARCH, Seq Scan, Index Scan, Bitmap Heap Scan)

Detailed notes for this lesson are being written. They appear here together with the video.