Skip to Content
0
Former Member
Apr 13, 2010 at 10:44 AM

Secondary index creation on ztable

125 Views

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