Thanks Pando.

None of our DBA's suggested that a remote table is brought to the local db.

If that is the case, can you explain this - when the select query is run by itself, it runs in sub second times.

Also, in one environment, the DBA's report that 4k is tranferred across the db link, whereas in the other environment, 56Mb is transferred.