topic Cluster tables in Application Development and Automation Discussions

Cluster tables

Former Member — Mon, 11 Dec 2006 04:22:25 GMT

Hi,

BSEG is a cluster table.I want to write a select statement from this table.But because it is a cluster table select stmt is taking long time to execute.Is there any way by which i can reduct this execution time.

Thanks

Ansari.

Re: Cluster tables

Former Member — Mon, 11 Dec 2006 04:28:22 GMT

Please use the following Secondary Index tables instead,depending on your requirement.

BSID Accounting: Secondary Index for Customers(Open Items)

BSIK Accounting: Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting: Secondary Index for G/L Accounts

BSAD Accounting: Secondary Index for Customers(Cleared Items)

BSAK Accounting: Secondary Index for Vendors(Cleared Items)

BSAS Accounting: Secondary Index for G/L Accounts(Cleared Items)

Re: Cluster tables

Sandeep_Panghal — Mon, 11 Dec 2006 05:04:39 GMT

Hi,

Try to use all the primary keys in WHERE clause also u can create ur own index based on the requirement.