Hi,
Information provided as requested. _temptable is a temporary table which contains a list of oids (integer, ~ 10 rows) to consider. Stats3 tbl idx neq nlt ndlt sample stack_elem idx_rel_stack_elem_soid 4 0 0 406 stack_elem idx_rel_stack_elem_oid 1 0 0 4 stack_elem idx_rel_stack_elem_oid 1 1 1 5 stack_elem idx_rel_stack_elem_oid 1 2 2 6 stack_elem idx_rel_stack_elem_oid 1 3 3 133 stack_elem idx_rel_stack_elem_soid_oid 4 0 0 406 Stats2 tbl idx stat stack idx_rel_stack_toid_rtype 210 1 1 stack_elem idx_rel_stack_elem_soid 4 4 stack_elem idx_rel_stack_elem_oid 4 1 stack_elem idx_rel_stack_elem_soid_oid 4 4 1 For query 2.1 selectid order from detail 1 0 0 SCAN TABLE stack_elem AS e USING INDEX idx_stack_elem_oid 1 1 1 SEARCH TABLE stack AS s USING INTEGER PRIMARY KEY (rowid=?) 1 2 2 SEARCH TABLE _temptable AS _t USING INTEGER PRIMARY KEY (rowid=?) 1 3 3 SEARCH TABLE _temptable AS _t2 USING INTEGER PRIMARY KEY (rowid=?) 2 0 1 SCAN TABLE stack AS s 2 1 2 SEARCH TABLE _temptable AS _t USING INTEGER PRIMARY KEY (rowid=?) 2 2 0 SEARCH TABLE rel_rel AS r USING COVERING INDEX idx_rel_rel (moid=?) 2 0 0 USE TEMP B-TREE FOR DISTINCT 2 0 0 USE TEMP B-TREE FOR ORDER BY 0 0 0 COMPOUND SUBQUERIES 1 AND 2 (UNION) For query 2.2 selectid order from detail 0 0 0 SEARCH TABLE stack USING INTEGER PRIMARY KEY (rowid=?) 0 0 0 EXECUTE LIST SUBQUERY 0 0 0 0 SCAN TABLE stack USING COVERING INDEX idx_stack_toid_rtype 0 1 1 SEARCH TABLE stack_elem USING COVERING INDEX idx_stack_elem_soid_oid (soid=?) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users