Wednesday, February 15, 2012

Improve Performance while Joining Small Local tables to Huge Remote Tables

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.

No comments:

Post a Comment