SQLite version 2.7.1 Enter ".help" for instructions sqlite> .explain sqlite> explain select lastname,firstname from person; addr opcode p1 p2 p3 ---- ------------ ---------- ------ ---------- 0 ColumnCount 2 0 1 ColumnName 0 0 lastname 2 ColumnName 1 0 firstname 3 Open 0 3 person 4 VerifyCookie 276 0 5 Rewind 0 10 6 Column 0 4 7 Column 0 3 8 Callback 2 0 9 Next 0 6 10 Close 0 0