强制索引

使用强制索引：51Testing软件测试网 v,T8g}#EB
查询内容中添加：/*+ index(column_name,index_name)*/51Testing软件测试网8A p\.z|8p k_

如：/*+ index(subscriber_attr,INX_SUBS_ATTR)*/51Testing软件测试网]#Kc6{Zs
select /*+ index(subscriber_attr,INX_SUBS_ATTR)*/ * from subscriber_attr 51Testing软件测试网,UMb@(Oflphu2Sj U
WHERE  key_id=5310805311710 AND expiretime>SYSDATE;

rvBh+@-{7I pj
k0
n/\zdYkc]5JJ0强制索引失效：
?~PhX.V6gCh`l9X0使索引失效：在where条件的索引字段中添加（column_name||''）51Testing软件测试网
ZQ`*m+gc0U+m-g

如：key_id||'' = '5310805311710' 51Testing软件测试网}5mu6`;_~0q
SELECT *
I
hF$\QoA~0  FROM subscriber_attr
t.]~
`-B`QtU0 WHERE key_id||'' = '5310805311710' and attr_id||'' = '84'51Testing软件测试网f@+d3L(`5C+w
   AND expiretime > SYSDATE;

:Nv
[kY` dz"f0 51Testing软件测试网?tIvU]j