V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
zhazhadi
V2EX  ›  问与答

oracle 建索引后查询慢

  •  
  •   zhazhadi · Aug 14, 2018 · 1883 views
    This topic created in 2824 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
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   4354 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 36ms · UTC 05:21 · PVG 13:21 · LAX 22:21 · JFK 01:21
    ♥ Do have faith in what you're doing.