- SAP Managed Tags:
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.
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"
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
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
