On 12.01.2013, at 07:10, Amit kapila <amit.kapila@huawei.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.