Secondary index creation on ztable

[Former Member]

Hi,

My requirement is to create secondary index on one custom table.

My custom table has below fields.

matid - primary key

material

material group

chart of account

gl account

creditor

I want to use 4 select statements in the program as below.

1. Get data from ztable on the basis of Material

2. Get data from ztable on the basis of Material Group

3. Get data from ztable on the basis of chart of account and gl account

4.Get data from ztable on the basis of creditor.

So my question is whether is it possible to create 4 indices on my ztable?

Also want to know whether the above selects will give better performance if indices are created?

Please reply ASAP.

Regards,

Shubhada

[Former Member]

Hi,

I think the secondary indices were scrutinised to the great detail on this forum..

However, to give you a hand in your case:

1) yes, you can create 4 secondary indices

2) performance should be tested after creation of the indices, but it make sense to create additional indices only if table is large. thus please consider how many records are you planning to have in this table, and if it is worth creating indices.

Maybe you should consider buffering this table instead ? In such case please take into account rules for table buffering which you can find in note 1011158.

Kind regards,

MC

[Former Member]

Hi Shubhada,

please refer the below link. It will give you info that what to keep in mind when you create a secondary index.

[http://help.sap.com/saphelp_NW70EHP1core/helpdata/en/cf/21eb2d446011d189700000e8322d00/frameset.htm]

[ThomasZloch]

Basic questions, please search before posting, don't request replies "ASAP".

Thread locked.

Thomas