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 .
