Check filter push-down with Analyze SQL (Database Explorer)

[jan_zwickel]

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