Jump to content
prathyushisakapalli

driving_site hint usage

Recommended Posts

Hi,

We're using dblinks to load data from db2 to Oracle. I've heard that using driving_site hint would benefit query fastness. But , would driving_site hint be useful while going with full table load ? 

Could you please help us in this . And what would be better approach for faster data load from db2 to Oracle .

Share this post


Link to post
Share on other sites

Thanks. But , here comes the confusion. Will parallel hint work for dblink as it gets the output via network in serial manner . I heard that we need to break the query with some where conditions to use db links parallely and get the output 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×