INDEX_STAT is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of INDEX_STAT in SAP.
- Table description : index_stats Cache: Result of VALIDATE Index (Oracle)
- Module : BC-CCM-MON-ORA
- Parent Module : BC
- Package : STUO
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP INDEX_STAT Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| NAME | Object: Name of table or index | DB_OBJECT | CHAR81 |
| DATUM | Date | DATUM | DATUM |
| UZEIT | Time | UZEIT | UZEIT |
| HEIGHT | height of the b-tree | HEIGHT | DEC14 |
| BLOCKS | Number of blocks | NUMBER_BLK | DEC14 |
| LF_ROWS | number of leaf rows (values in the index) | LF_ROWS | DEC14 |
| LF_BLKS | number of leaf blocks in the b-tree | LF_BLKS | DEC14 |
| LF_ROW_LEN | sum of the lengths of all the branch blocks | LF_ROW_LEN | DEC14 |
| LF_BLK_LEN | number of leaf blocks in the b-tree | LF_BLK_LEN | DEC14 |
| BR_ROWS | number of branch rows | BR_ROWS | DEC14 |
| BR_BLKS | number of branch blocks in the b-tree | BR_BLKS | DEC14 |
| BR_ROW_LEN | sum of the lengths of all the branch blocks | BR_ROW_LEN | DEC14 |
| BR_BLK_LEN | usable space in a branch block | BR_BLK_LEN | DEC14 |
| DEL_LF_ROW | number of deleted leaf rows in the index | DEL_LF_ROW | DEC14 |
| DEL_LF_LEN | total length of all deleted rows in the index | DEL_LF_LEN | DEC14 |
| DIST_KEYS | Number of distinct keys in index | DIST_KEYS | DEC14 |
| REP_KEYS | how many times the most repeated key is repeated | REP_KEYS | DEC14 |
| BTREE_SPAC | total space currently allocated in the b-tree | BTREE_SPAC | DEC14 |
| USED_SPACE | total space that is currently being used | USED_SPACE | DEC14 |
| PCT_USED | PCT_USED | PCT_USED_ | DEC14 |
| ROWS_PER_K | average number of rows per distinct key | ROWS_PER_K | DEC14 |
| BLKS_GETS | Expected number of consistent mode block gets per row | BLKS_GETS | DEC14 |
INDEX_STAT related tables
| Table | Note |
|---|---|
| INDEX_STAT | index_stats Cache: Result of VALIDATE Index (Oracle) |
| ORA_MON_DBCON | Oracle monitoring: list of external Oracle connections |
| SORAMON | Oracle: Permanent Storage for the Oracle Database Monitor |
| AGSDBG_CPSCBACK1 | To Validate SAP CPS Callback Functionality |
| AGSDBG_CPSCBACK2 | To Validate SAP CPS Callback Functionality |
| T77WWW_CLSTFL | Table to validate the status flow of the request |
| BC505IN | Table for fragmented index training, Oracle DBA courses |
| IAORA | Table type -> index storage parameters for ORACLE V6 |
| IGORA | Table category -> index storage parameters for ORACLE V6 |
| ORA_IND_QLTY | Oracle monitoring: Index storage quality |
| POWL_RESULT | Query result cache |
| SABP_ACC_CACHE | OBJECT TINTERNAL: * NO ACCESS OUTSIDE PACKAGE * Result Cache |
| JVTMCI_MERGE_RES | TMCI Merge Result: Merge Result for Ship-To Address |
| SMOTVC7 | Assignmt.: Result - Possible Reasons for Result |
| TZRR_VERDICT | TestZone: Result Repository Execution Result |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP