Lines Matching refs:ev

42     CREATE TABLE ev(y INT);
43     CREATE INDEX evy ON ev(y);
44     /* ev will hold 32 copies of 16 integers found in cat */
45     INSERT INTO ev SELECT x FROM cat;
46     INSERT INTO ev SELECT x FROM cat;
47     INSERT INTO ev SELECT y FROM ev;
48     INSERT INTO ev SELECT y FROM ev;
49     INSERT INTO ev SELECT y FROM ev;
50     INSERT INTO ev SELECT y FROM ev;
53     SELECT count(*) FROM ev;
63   eqp {SELECT count(*) FROM ev, cat WHERE x=y}
64 } {/*SCAN cat USING COVERING INDEX catx*SEARCH ev USING COVERING INDEX evy (y=?)*/}
70   SELECT count(*) FROM cat, ev WHERE x=y
74   `--SEARCH ev USING COVERING INDEX evy (y=?)