topic Re: Tuning cluster table selection in Application Development and Automation Discussions

Tuning cluster table selection

Former Member — Tue, 31 Aug 2004 05:02:08 GMT

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

Re: Tuning cluster table selection

thomas_jung — Tue, 31 Aug 2004 12:59:08 GMT

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.

Re: Tuning cluster table selection

Former Member — Tue, 31 Aug 2004 13:02:16 GMT

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.