SQL & PL/SQL

Hi,

Maybe it's a stupid question but I'm stucked.
I need to run a simple query on linked database. The query links two tables which a re quite large. Example of how the query looks like:

select
    atab.field_1
  , btab.field_2
from
    TABLE_A atab
  join
    TABLE_B btab on btab.field_1 = atab.field_1
where
    btab.field_3 = 'SAMPLE'

When run directly on remote database it runs very quickly since indexes are used. When run thtough link it becomes very slow since apparently indexes are not used:

select
    atab.field_1
  , btab.field_2
from
    TABLE_A@REMOTE atab
  join
    TABLE_B@REMOTE btab on btab.field_1 = atab.field_1
where
    btab.field_3 = 'SAMPLE'

Is there any way to run a full query on linked database?

I'm not allowed to create views on remote database which would be obvious solution :-(

Any help appreciated

Zbig