cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Data Virtualization optimisation

MattRogers
Explorer
0 Likes
1,033

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.

View Entire Topic
Sven_Knpfler
Active Participant

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):

https://help.sap.com/viewer/c1d3f60099654ecfb3fe36ac93c121bb/2021_4_QRC/en-US/a1fcde3545984c14a92cfb...

MattRogers
Explorer

Thanks Sven - really useful information to know - much appreciated!