Lines Matching refs:a1

184   CREATE TABLE a1(a, b, c, d);
185   CREATE INDEX a1a ON a1(a);
186   CREATE INDEX a1bc ON a1(b, c);
189   INSERT INTO a1 SELECT x, x, x, x FROM d;
193   SELECT d FROM a1 WHERE (a=4 OR b=13)
197   zExplain {SEARCH a1 USING INDEX a1a (a=?)}
199   zExplain {SEARCH a1 USING INDEX a1bc (b=?)}
203   SELECT count(*) FROM a1 WHERE (a BETWEEN 4 AND 12) OR (b BETWEEN 40 AND 60)
207   zExplain {SEARCH a1 USING INDEX a1a (a>? AND a<?)}
209   zExplain {SEARCH a1 USING INDEX a1bc (b>? AND b<?)}
213   SELECT count(*) FROM a1 AS x, a1 AS y 
224   SELECT count(*) FROM a1 WHERE a IN (1, 5, 10, 15);
228   zExplain {SEARCH a1 USING COVERING INDEX a1a (a=?)}
232   SELECT count(*) FROM a1 WHERE rowid IN (1, 5, 10, 15);
235   nLoop 1 nVisit 4 nEst 4.0 zName a1
236   zExplain {SEARCH a1 USING INTEGER PRIMARY KEY (rowid=?)}