Lines Matching refs:sqlite

490 # XVIDENCE-OF: R-47779-47605 sqlite> EXPLAIN QUERY PLAN SELECT a, b
499 # XVIDENCE-OF: R-55852-17599 sqlite> CREATE INDEX i1 ON t1(a);
500 # sqlite> EXPLAIN QUERY PLAN SELECT a, b FROM t1 WHERE a=1;
508 # XVIDENCE-OF: R-21179-11011 sqlite> CREATE INDEX i2 ON t1(a, b);
509 # sqlite> EXPLAIN QUERY PLAN SELECT a, b FROM t1 WHERE a=1;
517 # XVIDENCE-OF: R-09991-48941 sqlite> EXPLAIN QUERY PLAN
528 # XVIDENCE-OF: R-33626-61085 sqlite> EXPLAIN QUERY PLAN
538 # XVIDENCE-OF: R-04002-25654 sqlite> CREATE INDEX i3 ON t1(b);
539 # sqlite> EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE a=1 OR b=2;
549 # XVIDENCE-OF: R-24577-38891 sqlite> EXPLAIN QUERY PLAN
559 # XVIDENCE-OF: R-58157-12355 sqlite> CREATE INDEX i4 ON t2(c);
560 # sqlite> EXPLAIN QUERY PLAN SELECT c, d FROM t2 ORDER BY c;
568 # XVIDENCE-OF: R-13931-10421 sqlite> EXPLAIN QUERY PLAN SELECT
586 # XVIDENCE-OF: R-50892-45943 sqlite> EXPLAIN QUERY PLAN
600 # XVIDENCE-OF: R-46219-33846 sqlite> EXPLAIN QUERY PLAN
610 # XVIDENCE-OF: R-37879-39987 sqlite> EXPLAIN QUERY PLAN
622 # XVIDENCE-OF: R-44864-63011 sqlite> EXPLAIN QUERY PLAN