on ‎2022 Mar 16 3:47 PM
I believe that Data Warehouse Cloud does support join push-down and filter push-down for some connections but it doesn't seem easy to understand what connection do or don't support these features.
I've read that they are "typically supported in database to database" scenarios but that's a little vague.
I also know that you can look at the Remote Query logs to see what joins/filters are perhaps being applied - but again that's a little hit/miss.
Is there any documentation specifically around this.
Request clarification before answering.
There is also this system view "SYS"."ADAPTER_CAPABILITIES" that gives you detailed information about the capabilities of each adapter in regard to push down (SDA) and real time replication (CDC):
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Sven - really useful information to know - much appreciated!
| User | Count |
|---|---|
| 12 | |
| 9 | |
| 6 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.