Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
jan_zwickel
Advisor
Advisor
0 Kudos
This example is referenced in my other post about how to check the push-down of filters. Please have a look at the other post to get a better understanding of the context for this example

 

In the following an example will be shown how the feature "Visualize Plan" of SAP HANA Studio can be used to analyze the push-down of filters. When working with SAP HANA Studio please keep in mind the deprecation SAP Note 2465027

Execute statement that you want to analyze by right-clicking at it, selecting “Visualize Plan” and “Execute”:



Generating Visualize Plan through user interface

 

Now you can manually drill-down in the executed plan until you find the table in question (in our example “BusinessPartnerContacts”) or by searching in the "Operator List" for e.g., “basic predicate”s. These two options are shown next.

 

Manual drill-down


Drill-down iteratively to the table level by pressing the arrow highlighted below and check whether the filter is applied at the table:



Manual drill-down to table level via arrows

 



After drilling-down to table level the filter can be seen on table "BusinessPartnerContacts"

 

Here you see that the filter '7412697340' is indeed applied at table "BusinessPartnerContacts"


Searching in Operator List


Search for "basic predicate" in column "Operator Name" in tab "Operator List". This allows you to check on which level the filter is applied:

 



Filter for basic predicates in Operator List and check at which tables the filter is applied

 

In the screenshot above you can see that the filter is applied to table "BusinessPartnerContacts"

 

This example is referenced in my other post about how to check the push-down of filters. Please have a look at the other post to get a better understanding of the context for this example