cancel
Showing results for 
Search instead for 
Did you mean: 

Understanding of the table level information from SAP HANA Studio

Former Member
0 Kudos

Hello Gurus,

Need some clarification from following information provided by SAP HANA Studio.

I have a table REGIONS and the contents are as follows:

REGION_ID REGION_NAME

11      Europe

12      Americas

13      Asia

44      Middle East and Africa

15      Australia

6      Africa

The Runtime Information about the table is as follows:

Image# 1

Image# 2

Image# 3

  1. Total size in KB show in Image#2 and 3 are not matching. Why?
  2. Total size in KB show in Image#2 and Total Memory Consumption are not matching. Why?
  3. The values of Memory consumption in Main Storage and Delta Storage are not matching in Image# 1 and Image# 2. Why?
  4. Estimated Maximum Memory Consumption (Image# 1) and Estimated Maximum Size (Image# 2) are matching.
  5. Why the Loaded column Image# 2 is showing the value ‘PARTIALLY’. The table has just 6 rows and still partially loaded? Why?
  6. What is the significance of column Loaded in Image# 2 and 3 ?

Thanks,

Shirish.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Gurus,

Waiting for the reply !!

former_member182302
Active Contributor
0 Kudos

Have a look on this

That presentation should help you to answer the questions yourself

Regards,

Krishna Tangudu

lbreddemann
Active Contributor
0 Kudos

Krishna, if I ever need an advertising partner, you'd be the first I'd ask

former_member182302
Active Contributor
0 Kudos

Thanks Lars for choosing me . But I would rather say, for the excellent content you write in your articles just  won't need advertising

Regards,

Krishna Tangudu

Former Member
0 Kudos

Krishna,

This is exactly what I was looking for.

Thanks.

Shirish.

Answers (0)