Secondary index creation on ztable
My requirement is to create secondary index on one custom table.
My custom table has below fields.
matid - primary key
chart of account
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.