Lines Matching refs:i1
64 execsql { CREATE INDEX i1 ON t1(x) }
89 execsql { DROP INDEX i1 ; DROP INDEX i2 }
93 # Index i1 optimizes the WHERE x='2' constraint.
94 execsql { CREATE INDEX i1 ON t1(x) }
110 execsql { DROP INDEX i1 ; DROP INDEX i2 }
114 # Index i1 optimizes the min(y)
115 execsql { CREATE INDEX i1 ON t1(y) }
119 # Index i1 optimizes the min(y)
120 execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t1(y DESC) }
126 execsql { DROP INDEX i1 }
130 # Index i1 optimizes the max(y)
131 execsql { CREATE INDEX i1 ON t1(y) }
135 # Index i1 optimizes the max(y)
136 execsql { DROP INDEX i1 ; CREATE INDEX i1 ON t1(y DESC) }
141 execsql { DROP INDEX i1 }