topic Master Data and Transaction Data Table Index in Application Development and Automation Discussions

Master Data and Transaction Data Table Index

Former Member — Thu, 08 Mar 2007 17:58:27 GMT

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

Re: Master Data and Transaction Data Table Index

Former Member — Thu, 08 Mar 2007 18:03:35 GMT

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

Re: Master Data and Transaction Data Table Index

Former Member — Thu, 08 Mar 2007 18:04:59 GMT

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