THE CLOUD EXPEDITION! · Chapter 7
Two Engines, One Query
Dr. Velocity revs two imaginary engines. Ladies and gentleducks, welcome to the DUAL EXECUTION DERBY! Your laptop and MotherDucks cloud, racing in PARALLEL! Captain Cloudsworth drops an imaginary checkered flag. But HOW does it decide what runs where? Lets peek under the hood. Discover Dual Execution — using EXPLAIN to see how MotherDuck splits work between local and cloud engines.
Your task
Peek under the hood of a hybrid query. Use `EXPLAIN` on a query that joins local `pondville_residents` with cloud `dbquacks_cloud_expedition.duck_travels` to see how MotherDuck splits work between your laptop and the cloud. Tables: `pondville_residents` (local), `dbquacks_cloud_expedition.duck_travels` (MotherDuck, linked by `duck_id`).