Index not used
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: _oracle_L_list <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 May 2006 16:35:42 -0400
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@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
Other related posts:
