When joining the small local tables to a huge remote table, using the below hint helps improve the performance of the query.
select /*+ driving_site(a) */ col1,col2 from small_table, big_table@dblink a
where
small_table.xyz= a. xyz;
With this hint, the join or sort is done on the remote db instead of pulling each record to join on the local db, resulting the query to finish quickly.
select /*+ driving_site(a) */ col1,col2 from small_table, big_table@dblink a
where
small_table.xyz= a. xyz;
With this hint, the join or sort is done on the remote db instead of pulling each record to join on the local db, resulting the query to finish quickly.
No comments:
Post a Comment