Tuning cluster table selection

[Former Member]

Dear All

We are using BSEG cluster table in some of our reports. These programs are taking more time in RFBLG table and using sequential read.

I am not able to tune these selection as there is no possibility to create any index on cluster table.

Is there any method to tune the selection from cluster tables

Thanks in advance

Regards

Lakshmi

[thomas_jung]

I'm afraid there isn't too much you can do. If you select on anything but a key field, you are going to do a sequential read. Have you looked at some of the secondary index tables such as BSAD, BSID, BSAK, BSAS, BSIK, and BSIS. Often you can field the data you need in these tables instead of BSEG.

[Former Member]

Hi,

you can try with these secondary index tabels,

1.BSAK Accounting: Secondary Index for Vendors

2.BSAS Accounting: Secondary Index for G/L Accounts

3.BSIK Accounting: Secondary Index for Vendors

4.BSID Accounting: Secondary Index for Customers

5.BSIM Secondary Index, Documents for Material

6.BSAD Accounting: Secondary index for customers

7.BSIS Accounting: Secondary Index for G/L Accounts

Prabhu Rajesh.