hello experts,

i have someting like that...

select * from .....
.......
where tab1.col1= tab2.col1
and tab3.col2 = tab2.col2
and tab3.col3 = tab2.col3
and tab3.col4 = tab2.col4

what are the best indexes on colunms..? how many indexes do we need for
the best performence i mean the indexes should be created on
tab1.IDX1(col1)..and tab2.IDX2(col1) and tab2.IDX(col2,col3,col4) and
tab3(col2,col3,col4) etc....
what are your suggestions...?

thanks in advance.
david..


Oracle LazyDBA home page