topic Re: table index in Application Development and Automation Discussions

table index

Former Member — Fri, 10 Aug 2007 13:03:01 GMT

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

Re: table index

Former Member — Fri, 10 Aug 2007 13:05:34 GMT

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

Re: table index

Former Member — Fri, 10 Aug 2007 13:05:52 GMT

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

Regards

Peram

Re: table index

Former Member — Fri, 10 Aug 2007 13:12:51 GMT

Hi,

Here is the link to create the secondary index

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

Regards

Sudheer

Re: table index

Former Member — Fri, 10 Aug 2007 13:15:23 GMT

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

Re: table index

Former Member — Fri, 10 Aug 2007 13:19:37 GMT

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

Re: table index

Former Member — Fri, 10 Aug 2007 14:03:11 GMT

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

Re: table index

Former Member — Fri, 10 Aug 2007 15:49:06 GMT

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.