ABAP Meets SAP HANA: What You Need to Know

6 important questions on ABAP Meets SAP HANA: What You Need to Know

Display table from dictionary?

But000 -> search name -> utility -> data base options -> display

Name on data base specific indices that is not needed anymore

Column indice because of column store

How does dictionary works to compress a colum?

For one specific column => create a dictionary for unique value and give it an index => save for each row( enumerated nach position) only the index from dictionary
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

For what the inverted index is used?

From dictionary entry x value y, contruct othe dictionary where entry x show all position where y is referenced

Your ABAP application uses an ABAP Dictionary table. The non-unique index that exists for this table is not needed on the SAP HANA database.
How can you control the creation of this index on the database?

Define an exclusion list for the database index in the ABAP Dictionary transaction (SE11)

Why non unique index for ABAP Dictionary table is not required for SAP Hana database?

Because of the column store

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo