add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id parent notused detail
2 0 0 SEARCH TABLE T USING COVERING INDEX T_Path (Path>? AND Path<?)
addr opcode p1 p2 p3 p4 p5 comment
0 Init 0 11 0 00 null
1 OpenRead 0 2 0 2 00 null
2 Rewind 0 10 0 00 null
3 Column 0 1 3 00 null
4 Function0 1 2 1 like(2) 02 null
5 IfNot 1 9 1 00 null
6 Rowid 0 4 0 00 null
7 Column 0 1 5 00 null
8 ResultRow 4 2 0 00 null
9 Next 0 3 0 01 null
10 Halt 0 0 0 00 null
11 Transaction 0 0 2 0 01 null
12 String8 0 2 0 abcd% 00 null
13 Goto 0 1 0 00 null
id parent notused detail
2 0 0 SEARCH TABLE T USING COVERING INDEX T_Path (Path>? AND Path<?)
addr opcode p1 p2 p3 p4 p5 comment
0 Init 0 11 0 00 null
1 OpenRead 1 4 0 k(2,,) 00 null
2 String8 0 1 0 abcd 00 null
3 SeekGE 1 10 1 1 00 null
4 String8 0 1 0 abce 00 null
5 IdxGE 1 10 1 1 00 null
6 IdxRowid 1 2 0 00 null
7 Column 1 0 3 00 null
8 ResultRow 2 2 0 00 null
9 Next 1 5 0 00 null
10 Halt 0 0 0 00 null
11 Transaction 0 0 2 0 01 null
12 Goto 0 1 0 00 null