Master Data and Transaction Data Table Index

[Former Member]

Hi Everyone

1. <b>Please tell how to find the data base size of table .</b>

2. have a requirement to find the data base size of tables in ECC 6.0 and then create index since we have some enhancement in data sources based on these tables. We want to create the index on the table that supply data to datasource and then it flow to cube in BI. Please let me know some tips on indexing or send me any documents on indexing at cube and tables level to improve performance

Thanks

soniya

null

[Former Member]

Hi,

Please check this FM.

BKC/RFC_GET_TABLE_SIZE

/SDF/INF_TOP_TABLES

/SDF/MSS_TEXT_IMAGE_FIELDS

GET_TABLE_SIZE_DB4

GET_TABLE_SIZE_DB6

MSS_GET_DB_SIZE_DETAILS

MSS_GET_SCHEMA_SIZE_INFO

MSS_GET_TABLE_SIZE_INFO

SFMSS_SIZE

GET_TABLE_SIZE_MSS

Also check with transaction DB02/DB16/DB17.

Regards,

Ferry Lianto

[Former Member]

Hi,

For the table length..

Display the table in SE11..Then in the menu choose..EXTRAS -> TABLE LENGTH..

You will get the table width..

Thanks,

Naren