Can anyone help me query Optimization
I used two tables A & B
when querying from A its perfect but when I join it with B it took 5 min and return on 60k records.
I tried to find out reason and found there is no index on that table(only Non-unique indexes) and table contains 20 millions of records.
Now the problem is index can not be created on that table and neither it can be drop or recreate ..
All stats are gathered already
can anyone suggest something on this..
Thanks in Advance