Index not used

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Tue, 16 May 2006 16:35:42 -0400
Message-ID: <367369f10605161335g35e3118docb045078225ec19e@mail.gmail.com>

Hi List,

SELECT *
 2 FROM tab1 t1 ,

 3        tab2 t2 ,
 4        tab3 t3
 5  WHERE t1.id = t2.id

 6 AND t2.id = t3.id
 7 AND t1.type IN
 8 ('A','B','C')
 9 AND t3.type = 'A'
10* AND t3.start_date = '01-APR-2004'

All join cols are indexed on leading cols. There is FTS on t2 . Stats are fresh and computed .
Why FTS on t2 ? ( v 9.2 ).
--

Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 16 2006 - 15:35:42 CDT