I am trying to tune a query.
Basically I joinning two table A,B on columns Col1. both having different Indexes
Example: select * from Table1 A
inner join Table2 B
on A.Col1 = B.Col1
and A.Col2 = B.Col2
In table A Col1 is defined in Join Index and in Table B Col1 is defined as SI.
and Col2 is not defined as any Index types..
I just wanted to know how i can tune this query and created SI on Column2 for both but still facing performance issue.
Please help me guys
Thanks a lot in advance :) ;)
Need more detail. For example:
How unique / non-unique are Col1 alone, Col2 alone, combined (Col1,Col2)?
How big is table1 vs table2?