Re: Slow query

Thanks. I will definitely give that a try. a and b are different tables.

>This hinders many optimization possiblities (like hash joining etc.).
>As soon as the oracle sees an _at_ sign in the from clause it assumes a
>distributed query and uses much more restrictive rules.
>You might speed the query by transporting the whole claims table to system
>b and do the select there.
>
>If a and b are really the same database use the same aliase even if it is
 in
>a different schemas.
>
>You might get better answers if you post your question to the
>comp.databases.oracle.server group and include the query plan.
>
>Willem Dekker
>
>
>
Received on Thu Aug 24 2000 - 15:57:07 CEST