Listing 1: VDBE program for a simple query.
SQLite version 2.8.0 Enter ".help" for instructions sqlite> explain select projectname_short from project ...> order by rating desc limit 10; 0 ColumnName 0 0 projectname_short 1 Integer -10 0 2 MemStore 0 1 3 Integer 0 0 4 OpenRead 0 3 project 5 VerifyCook 0 1476 6 Rewind 0 13 7 Column 0 3 8 SortMakeRe 1 0 9 Column 0 11 10 SortMakeKe 1 0 11 SortPut 0 0 12 Next 0 7 13 Close 0 0 14 Sort 0 0 15 SortNext 0 19 16 MemIncr 0 19 17 SortCallba 1 0 18 Goto 0 15 19 SortReset 0 0 20 Halt 0 0