Skip to Content

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply