``` SQLite version 3.34.0 2020-10-07 11:31:14 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE item ( ...> date_time TIMESTAMP NOT NULL, ...> item_id INTEGER NOT NULL, ...> list_id VARCHAR NOT NULL, ...> unique_id VARCHAR(36), ...> object_type INTEGER, ...> author_id INTEGER, ...> guid VARCHAR(36), ...> editor_id INTEGER, ...> created TIMESTAMP, ...> folder VARCHAR(255), ...> type VARCHAR(128), ...> leaf_ref VARCHAR(64), ...> uri VARCHAR(255), ...> content_type VARCHAR(255), ...> file_ref VARCHAR(255), ...> title VARCHAR(128), ...> modified TIMESTAMP, ...> tag INTEGER, ...> related VARCHAR(64), ...> redirect VARCHAR(64), ...> parent_guid VARCHAR(36), ...> relocated INTEGER(1) DEFAULT 0, ...> attributes JSON, ...> keyword VARCHAR, ...> deleted_date_time TIMESTAMP ...> ); sqlite> create index item_index on item (list_id, item_id, modified); sqlite> .eqp full sqlite> select * from item where list_id='158a499e-4432-4073-a73b-9396cae17f42' and item_id=10209335 and modified=1500007910000; QUERY PLAN `--SEARCH TABLE item USING INDEX item_index (list_id=? AND item_id=? AND modified=?) (~8 rows) addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Init 0 45 0 0 Start at 45 1 OpenRead 0 2 0 25 2 root=2 iDb=0; item 2 ColumnsUsed 0 0 0 33554431 0 3 OpenRead 1 3 0 k(4,,,,) 2 root=3 iDb=0; item_index 4 ColumnsUsed 1 0 0 7 0 5 Explain 5 0 0 SEARCH TABLE item USING INDEX item_index (list_id=? AND item_id=? AND modified=?) (~8 rows) 0 6 Noop 0 0 0 0 Begin WHERE-loop0: item 7 CursorHint 1 0 0 AND(AND(EQ(c0,'158a499e-4432-4073-a73b-9396cae17f42'),EQ(c1,10209335)),EQ(c2,63534568)) 0 8 String8 0 1 0 158a499e-4432-4073-a73b-9396cae17f42 0 r[1]='158a499e-4432-4073-a73b-9396cae17f42' 9 Integer 10209335 2 0 0 r[2]=10209335 10 Int64 0 3 0 1500007910000 0 r[3]=1500007910000 11 SeekGE 1 43 1 3 0 key=r[1..3] 12 IdxGT 1 43 1 3 0 key=r[1..3] 13 DeferredSeek 1 0 0 0 Move 0 to 1.rowid if needed 14 Noop 0 0 0 0 Begin WHERE-core 15 Column 0 0 4 0 r[4]=item.date_time 16 Column 1 1 5 0 r[5]=item.item_id 17 Column 1 0 6 0 r[6]=item.list_id 18 Column 0 3 7 0 r[7]=item.unique_id 19 Column 0 4 8 0 r[8]=item.object_type 20 Column 0 5 9 0 r[9]=item.author_id 21 Column 0 6 10 0 r[10]=item.guid 22 Column 0 7 11 0 r[11]=item.editor_id 23 Column 0 8 12 0 r[12]=item.created 24 Column 0 9 13 0 r[13]=item.folder 25 Column 0 10 14 0 r[14]=item.type 26 Column 0 11 15 0 r[15]=item.leaf_ref 27 Column 0 12 16 0 r[16]=item.uri 28 Column 0 13 17 0 r[17]=item.content_type 29 Column 0 14 18 0 r[18]=item.file_ref 30 Column 0 15 19 0 r[19]=item.title 31 Column 1 2 20 0 r[20]=item.modified 32 Column 0 17 21 0 r[21]=item.tag 33 Column 0 18 22 0 r[22]=item.related 34 Column 0 19 23 0 r[23]=item.redirect 35 Column 0 20 24 0 r[24]=item.parent_guid 36 Column 0 21 25 0 0 r[25]=item.relocated 37 Column 0 22 26 0 r[26]=item.attributes 38 Column 0 23 27 0 r[27]=item.keyword 39 Column 0 24 28 0 r[28]=item.deleted_date_time 40 ResultRow 4 25 0 0 output=r[4..28] 41 Noop 0 0 0 0 End WHERE-core 42 Next 1 12 1 0 43 Noop 0 0 0 0 End WHERE-loop0: item 44 Halt 0 0 0 0 45 Transaction 0 0 2 0 1 usesStmtJournal=0 46 Goto 0 1 0 0 sqlite> ```