Kontakt

Ansicht
Dokumentation

10130 - How do I get the size of an INDEX for a SAP ta ble?

10130 - How do I get the size of an INDEX for a SAP ta ble?

rdisp/max_wprun_time - Maximum work process run time   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

How do I get the size of an INDEX for a SAP ta ble?

Hi,

have a look to the table DBSTATTDB4 or if you need the history as well to
DBSTATHDB4.

Regards

Volker

-----Original Message-----
From: SAP on AS400 [mailto:balshetty_as400_sapZhotmail.com]
Sent: Freitag, 9. Mai 2003 21:42
To: DoNotReply@consolut.eu
Subject: How do I get the size of an INDEX for a SAP
table?


Hello all,

I have a need to find the size of all index (default index and all custom index)
for a given SAP defined table. I can get the name of index table/file either in
SAP DDIC or in SYSINDEXES table in AS/400. And AS/400 we can display the file
properties for an INDEX file but not sure how I can query the index size (in
bytes or KB or MB) within SAP, either using ABAP functions or native/open SQL or
running AS/400 command using CALL function...

Thanks in advance...

-Bala


[Non-text portions of this message have been removed]



Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu

Your use of consolut is subject to http://www.consolut.net


 Durban Tours - Südafrika Safari

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 2044 Date: 20240520 Time: 153020     sap01-206 ( 2 ms )