/EXPLAIN AutoIndex query
Created Jul 18, 2014
| addr opcode p1 p2 p3 p4 p5 comment | |
| ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- | |
| 0 Init 0 44 0 00 | |
| 1 Integer 10 1 0 00 | |
| 2 OpenRead 1 214248 0 6 00 | |
| 3 OpenRead 2 2 0 0 00 | |
| 4 OpenRead 3 4184000 0 0 00 | |
| 5 OpenRead 0 24914 0 1 00 | |
| 6 Once 0 16 0 00 | |
| 7 OpenAutoin 4 4 0 k(4,nil,ni 00 | |
| 8 Rewind 1 16 0 00 | |
| 9 Column 1 4 3 00 | |
| 10 Column 1 5 4 00 | |
| 11 Column 1 0 5 00 | |
| 12 Rowid 1 6 0 00 | |
| 13 MakeRecord 3 4 2 00 | |
| 14 IdxInsert 4 2 0 10 | |
| 15 Next 1 9 0 03 | |
| 16 Integer 300 7 0 00 | |
| 17 Integer 6 8 0 00 | |
| 18 SeekGE 4 41 7 2 00 | |
| 19 IdxGT 4 41 7 2 00 | |
| 20 Column 4 2 9 00 | |
| 21 MustBeInt 9 40 0 00 | |
| 22 NotExists 2 40 9 00 | |
| 23 Rewind 3 40 0 00 | |
| 24 Once 1 32 0 00 | |
| 25 OpenAutoin 5 2 0 k(2,nil,ni 00 | |
| 26 Rewind 0 32 0 00 | |
| 27 Column 0 0 3 00 | |
| 28 Rowid 0 4 0 00 | |
| 29 MakeRecord 3 2 2 00 | |
| 30 IdxInsert 5 2 0 10 | |
| 31 Next 0 27 0 03 | |
| 32 IsNull 9 39 0 00 | |
| 33 SeekGE 5 39 9 1 00 | |
| 34 IdxGT 5 39 9 1 00 | |
| 35 Column 5 0 11 00 | |
| 36 ResultRow 11 1 0 00 | |
| 37 IfZero 1 41 -1 00 | |
| 38 Next 5 34 0 00 | |
| 39 Next 3 24 0 01 | |
| 40 Next 4 19 0 00 | |
| 41 Close 2 0 0 00 | |
| 42 Close 3 0 0 00 | |
| 43 Halt 0 0 0 00 | |
| 44 Transactio 0 0 27 0 01 | |
| 45 TableLock 0 214248 0 l 00 | |
| 46 TableLock 0 2 0 v 00 | |
| 47 TableLock 0 4184000 0 m 00 | |
| 48 TableLock 0 24914 0 a 00 | |
| 49 Goto 0 1 0 00 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment