强制索引

使用强制索引：
k2pyB"d#L;a"s0查询内容中添加：/*+ index(column_name,index_name)*/

%k'u.K"leUY^;U0如：/*+ index(subscriber_attr,INX_SUBS_ATTR)*/51Testing软件测试网SYw.w.F2kq
select /*+ index(subscriber_attr,INX_SUBS_ATTR)*/ * from subscriber_attr
4z!q;_N7ckE0WHERE  key_id=5310805311710 AND expiretime>SYSDATE;51Testing软件测试网;?d-SW3mDN,v!L

al/JM gqb051Testing软件测试网u9WzPkK
强制索引失效：
v.J C"IXf-Iy0使索引失效：在where条件的索引字段中添加（column_name||''）

s%RXG4b
T4k0如：key_id||'' = '5310805311710'
QK-cg] t:}.jH,_#U0SELECT *51Testing软件测试网 gz
bQ7J;F+B
  FROM subscriber_attr
?)v4nH-z W:O\#f0 WHERE key_id||'' = '5310805311710' and attr_id||'' = '84'51Testing软件测试网rX+?j){ ~,C
   AND expiretime > SYSDATE;

{{jL/G7D1S/T-j[8?D0 51Testing软件测试网-ZShfk