On 12.01.2013, at 07:10, Amit kapila <amit(dot)kapila(at)huawei(dot)com> wrote:
> You can try once with below query:
> Select * from (SELECT a.id,b.value FROM table_a a, table_b b WHERE ... AND ... ) X where X.value=...;
>
> If this doesn't work can you send the Explain .. output for both queries(the query you are using and the query I have suggested)
>
> With Regards,
> Amit Kapila.
Hi and thank you!
I will try this and let you know!
T.