table index

[Former Member]

I am having performance issues with data access on the MSEG table because it contains more than 3 ml records. How to speed up the access. How to create an index of the table. Thank you

[Former Member]

Hi Megan

when u r retireving data from mseg and bseg tables u should use all the key fields in where condition,

try to post u r code here for getting good results,

reward points to all helpful answers

kiran.M

[Former Member]

SE11->display->Indexes(Push Button)->create->where u have to list out fields on which u want to create Index.

Regards

Peram

[Former Member]

Hi,

Here is the link to create the secondary index

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/frameset.htm

Regards

Sudheer

[Former Member]

forget it, if you don't know than you are definitely not the person who is allowed to create an index on such a large table !!

Indexes are not cost-free, they need space and add effort in inserts and updates.

So you should be careful when you want to create indexes, and more careful if the table is large. For table with more than 1 mio records, there is rarely an agreement that an index must be added.

How important is your coding and are you sure that the coding is already optimal?

Siegfried

[Former Member]

Hi Megan,

First,

Try to search for some FM for which fetches data from MSEG table.

check this link for creating secondary index

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm

regards,

ALI

[Former Member]

Megan - Siegfried is right about not creating indexes on SAP tables.It will tend to slow processing down every time the table is updated. Since this is just a single SELECT, the better option is to speed up the code. Can you post that portion please?

Rob

[Former Member]

Folks, Thanks for your responses. I have decided to not use MSEG altogether and yeah you are right, coming to an agreement on indexes was very difficult here.