执行sql如下：
select *
from lm3.cc03
where aae017 in (
select distinct natl.jgid
from be3.agency_natl natl,
be3.agency_config conf
where natl.jgid = conf.jgid
and conf.ywlb = '02'
start with natl.jgid = '37100106'
connect by prior conf.jgid = conf.sjjgid
)
and aae036 >= to_date('20130101', 'yyyyMMdd')
lm3.cc03表中有aae017和aae036 的组合索引，也有aae036 的单独索引。
但是执行以上sql时，lm3.cc03检索用不上索引，为什么？
哪位大侠给指导一下，谢谢！
不要用in，改为exists
select *
from lm3.cc03
where exists (
select distinct natl.jgid
from be3.agency_natl natl,
be3.agency_config conf
where natl.jgid = conf.jgid
and natl.jgid = aae017
and conf.ywlb = '02'
start with natl.jgid = '37100106'
connect by prior conf.jgid = conf.sjjgid
)