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
Product and Topic Expert
Product and Topic Expert
844
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 it will be demonstrated with an example how the feature "Analyze SQL" of the SAP HANA Database Explorer can be used to analyze the push-down of filters.

 

Run "Analyze SQL" in database explorer on the statement by selecting from the options of the green arrow:



Drop-Down of green arrow in SAP HANA Database Explorer allows running of "Analyze SQL"

 

1. Configure displayed information


Use the settings button to select which columns to display:



Selecting columns to display

 

Select at least "Operator Name", "Accessed DB Objects", and "Details":



Columns "Operator Name", "Accessed DB Objects" and "Details" are selected

 

2. Analyze displayed information


Sort based on "Operator Name" by using "Sort" button:



Sort button allows sorting based on selected column

 

You should now see something similar to the screenshot below. If there are too many entries you can filter for "Basic predicate" using the Filters button



Details for individual operators sorted by "Operator Name"

 

In the screenshot above you can see that the filter on field "Phone_Number" is indeed applied at "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
2 Comments