Lines Matching refs:explain
16 # $Id: speed1p.explain,v 1.1 2008/04/16 12:57:48 drh Exp $
97 explain {INSERT INTO t1 VALUES($i,$r,$x)}
115 explain {INSERT INTO t2 VALUES($i,$r,$x)}
136 explain {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
153 explain {SELECT count(*), avg(b) FROM t1 WHERE c LIKE $pattern}
160 explain {CREATE INDEX i1a ON t1(a)}
161 explain {CREATE INDEX i1b ON t1(b)}
184 explain {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
201 explain {SELECT c FROM t1 WHERE rowid=$id}
218 explain {SELECT c FROM t1 WHERE a=$id}
231 explain {SELECT c FROM t1 WHERE c=$c}
253 explain {UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr}
270 explain {UPDATE t1 SET b=$r WHERE a=$i}
277 explain {UPDATE t1 SET c=a}
295 explain {UPDATE t1 SET c=$x WHERE a=$i}
302 explain {DELETE FROM t1}
307 explain {INSERT INTO t1 SELECT * FROM t2}
312 explain {DELETE FROM t1 WHERE 1}
321 explain {DROP TABLE t1}
322 explain {CREATE TABLE tX(a INTEGER, b INTEGER, c TEXT)}
337 explain {SELECT rowid FROM t1 ORDER BY random() LIMIT 20000}
344 explain {DELETE FROM t1 WHERE rowid IN