| adm | Find | login register |
eliu joined: 2007-08-09 posted: 11474 promoted: 617 bookmarked: 187 新竹, 台灣 |
理論上 SELECT LIKE 'xxxx%' 應該可以用 INDEX search,結果沒有,不知道為什麼? 難道與 PRIMARY KEY 有關?還是 bug ?
db =# explain SELECT seq FROM tab WHERE str like 'edt%'; | ||||||||
eliu joined: 2007-08-09 posted: 11474 promoted: 617 bookmarked: 187 新竹, 台灣 |
| ||||||||
eliu joined: 2007-08-09 posted: 11474 promoted: 617 bookmarked: 187 新竹, 台灣 |
原來是要這樣。 edited: 4
|
| adm | Find | login register |