Lines Matching refs:zExplain

48   nLoop 1 nVisit 2 nEst 1048576.0 zName t1 zExplain {SCAN t1}
49   nLoop 2 nVisit 6 nEst 1048576.0 zName t2 zExplain {SCAN t2}
57   nLoop 1 nVisit 2 nEst 2.0 zName t1 zExplain {SCAN t1}
58   nLoop 2 nVisit 6 nEst 3.0 zName t2 zExplain {SCAN t2}
66   nLoop 1 nVisit 2 nEst 2.0 zName t2 zExplain 
68   nLoop 2 nVisit 4 nEst 2.0 zName t1 zExplain {SCAN t1}
76   nLoop 2 nVisit 4 nEst 2.0 zName t2 zExplain 
78   nLoop 4 nVisit 8 nEst 2.0 zName t1 zExplain {SCAN t1}
86   nLoop 0 nVisit 0 nEst 2.0 zName t2 zExplain 
88   nLoop 0 nVisit 0 nEst 2.0 zName t1 zExplain {SCAN t1}
108   zExplain {SEARCH x1 USING INTEGER PRIMARY KEY (rowid=?)}
116   zExplain {SEARCH x1 USING COVERING INDEX x1j (j=?)}
124   zExplain {SEARCH x1 USING COVERING INDEX x1j (j<?)}
132   zExplain {SEARCH x1 USING COVERING INDEX x1j (j>?)}
140   zExplain {SEARCH x1 USING COVERING INDEX x1j (j>? AND j<?)}
153   zExplain {SEARCH x2 USING INDEX x2j (j>? AND j<?)}
161   zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}
169   zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}
177   zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}
197   zExplain {SEARCH a1 USING INDEX a1a (a=?)}
199   zExplain {SEARCH a1 USING INDEX a1bc (b=?)}
207   zExplain {SEARCH a1 USING INDEX a1a (a>? AND a<?)}
209   zExplain {SEARCH a1 USING INDEX a1bc (b>? AND b<?)}
218   zExplain {SEARCH y USING COVERING INDEX a1bc (b>? AND b<?)}
220   zExplain {SEARCH x USING COVERING INDEX a1a (a>? AND a<?)}
228   zExplain {SEARCH a1 USING COVERING INDEX a1a (a=?)}
236   zExplain {SEARCH a1 USING INTEGER PRIMARY KEY (rowid=?)}
269   zExplain {SEARCH p1 USING INDEX sqlite_autoindex_p1_1 (x=?)}
271   nLoop 1 nVisit 3 nEst 262144.0 zName c1 zExplain {SCAN c1}
316   zExplain {SCAN ii USING COVERING INDEX t1bc}
318   zExplain {SEARCH t1 USING COVERING INDEX sqlite_autoindex_t1_1 (a=?)}
326   zExplain {SEARCH t1 USING COVERING INDEX sqlite_autoindex_t1_1 (a=?)}
336   nLoop 1 nVisit 19 nEst 56.0 zName t2xy zExplain
352   zExplain {SCAN t1 USING COVERING INDEX t1bc}
354   zExplain {SEARCH t2 USING COVERING INDEX t2xy (ANY(x) AND y=?)}
368   nLoop 1 nVisit 501 nEst 480.0 zName t3 zExplain {SCAN t3}
369   nLoop 501 nVisit 200 nEst 20.0 zName auto-index zExplain
394     nLoop 1 nVisit 6 nEst 24.0 zName ft1 zExplain