Skip to Content
Author's profile photo Jan Zwickel

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

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

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ANIRUDDHA SHINDE
      ANIRUDDHA SHINDE

      What is SAP HANA version where these features are available?

      Author's profile photo Jan Zwickel
      Jan Zwickel
      Blog Post Author

      Analyze SQL is available in the Database Explorer since HANA 2.0, SPS00. You need XSA to run the Database Explorer.