oracle 建索引后查询慢

This topic created in 2875 days ago, the information mentioned may be changed or developed.

select * from USER where USER_NAME = '湘 123' 很慢；
select * from USER where USER_NAME = '123' 很快；
USER_NAME 建了索引的，中文开头查询，有一些快（像 USER_NAME = '你 123'）；‘粤 123 ’就几秒，‘湘 123 ’就更慢了，为什么呢？

No Comments Yet

user_name select user 索引