Tuning cross-database SQL queries

In February's session, Chris looked at options for tuning distributed queries; aka those using database links.

Highlights include:

06:10 - Challenges with getting the execution plan for distributed queries
08:00 - How to get execution details for the queries run on the remote DBs
15:00 - How to minimize network roundtrips to improve DB link queries:
17:10 - The driving_site hint
21:50 - Use the no_merge hint to ensure joins happen remotely
25:00 - Remove the network from the equation by using materialized views
27:30 - Demo of how to diagnose and tune a distributed query
37:25 - Recap of process for diagnosing and tuning database link queries

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.

#sql #distributed