When one does a query that joins a local data source like Access or Excel with a large Oracle table, does Toad for Data Analysis try to retrieve the whole Oracle table to the local machine to do the join, or does it upload the local table into a temp oracle table to let Oracle do the join?
Generally, one should have some filtering clause on the Oracle table (e.g. where oracle_table.primary_key_column = :value ) or else the query will probably try to retrieve the whole Oracle table down to the client to join to the result set gathered from the other tables in the heterogeneous query.
