Questions on Limits for SAP HANA

1) What is the maximum number of tables in a schema?

131072
 

2) What can be the maximum table name length?

127 characters
 

3) What can be the maximum column name length?

127 characters
 

4) What can be the maximum number of columns in a table?

1000
 

5) What can be the maximum number of columns in a view?

1000
 

6) What can be the maximum number of partitions of a column table?

1000
 

7) What can be the maximum number of rows  in each table?

Limited by storage size RS: 1TB/sizeof(row)
CS: 2^31 * number of partitions
 

8) In which table you can get the current system limits?

M_SYSTEM_LIMITS
 

9) Maximum number of jobs you can view the information in the Current tab of Job log?

5

SAP HANA

SAP HANA
SAP HANA Hints and Tips

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.