List the top tables in maxdb query

[Former Member]

Hi Team,   

Is there any query which we can query according to size, i want to list some 10 to 20 tables in a database according to size.

[former_member229109]

Hello,

What is the version of your database?

1.

Check:

http://maxdb.sap.com/doc/7_7/45/2d5256d79f3446e10000000a155369/content.htm

“The statistics system table <DATABASE_SYSTEM_ADMINISTRATOR>.TABLESTATISTICS contains information about the structure and sizes of base tables.”

Example:

select OWNER,TABLENAME,

        NUMERIC_VALUE page_count

from tablestatistics

where description = 'Used  pages'

and :

“The system table SYSINFO.TABLESIZE contains size information about tables.”

http://maxdb.sap.com/doc/7_7/45/2c341e90154c2de10000000a1553f6/content.htm

Example:

select * from tablesize order by ROWCOUNT

2.

If you are SAP customer and your system connected to MAXDB for monitoring, please read the document:

http://help.sap.com/saphelp_nw70/helpdata/en/c2/36c5067754044db2b91b00ba60b36a/content.htm

In the Statistics user menu on SAP R/3 system, /ndb59, monitoring your DB, you can find, among other things, a display of statistics about table sizes and growth in the user menu Table Sizes.

Regards, Natalia Khlopina

[Former Member]

Hi Natalia,

Thanks a ton for the amazing response,

My requirement is that i need to list the top 300 tables by size from maxdb can we do it using the system tables as mentioned.

[yashwanthkumar_kethineed]

Hi,

You can find required information about table sizes in the documentation below:

http://help.sap.com/saphelp_nw70/helpdata/en/c2/36c5067754044db2b91b00ba60b36a/content.htm

Hope this answers your question.

Regards,

Yashwanth