Lines Matching refs:key1
5 key1 int(11),
8 KEY key1 (key1),
16 explain select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
18 1 SIMPLE t1 index_merge key1,key2 key1,key2 5,5 NULL 5 Using sort_union(key1,key2); Using where
19 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
20 pk1 key1 key2
29 key1 int(11),
32 KEY key1 (key1),
40 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
41 pk1 key1 key2
50 key1 int(11),
53 KEY key1 (key1),
60 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
61 pk1 key1 key2
71 key1 int(11),
74 KEY key1 (key1),
81 insert ignore into t1 select pk1, char(0xEC), pk3, key1, key2 from t1;
82 insert ignore into t1 select pk1, 'x', pk3, key1, key2 from t1 where pk2='u';
83 insert ignore into t1 select 2, pk2, pk3, key1, key2 from t1;
85 pk1 pk2 pk3 key1 key2
104 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
105 pk1 pk2 pk3 key1 key2
126 pk1 pk2 pk3 key1 key2
145 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
146 pk1 pk2 pk3 key1 key2
169 key1 int(11),
172 KEY key1 (key1),
180 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
181 pk1 pk2 key1 key2