sqlite

SQLite Temp B-Tree

Sorting using a temporary B-Tree.

SELECT * FROM tracks ORDER BY Milliseconds;

USE TEMP B-TREE FOR ORDER BY means the result set was too large or unsorted, so SQLite built a temporary structure to sort the results.

Interactive Execution Plan

EXPLAIN Output

Run: EXPLAIN QUERY PLAN your_query;

Enter SQL EXPLAIN output to visualizeSupports PostgreSQL EXPLAIN ANALYZE, MySQL EXPLAIN, and SQLite EXPLAIN QUERY PLAN formats