topic Performance Issue with table A005 in Application Development and Automation Discussions

Performance Issue with table A005

former_member239066 — Tue, 22 Dec 2009 11:27:21 GMT

Hi Experts,

I am performing a select - for all entries on the table A005 (pooled table) and it is taking a lot of time. Can anyone please suggest an alternative? Is it a performance issue perform a for all entries on a pooled table?

Thanks,

Vitz.

Re: Performance Issue with table A005

Former Member — Tue, 22 Dec 2009 11:34:54 GMT

Try to use maximum key fields in u r select statement.

Use following fields as key in u select statment.

KAPPL

KSCHL

VKORG

VTWEG

KUNNR

MATNR

Regards,

Raghu.

Re: Performance Issue with table A005

Former Member — Tue, 22 Dec 2009 11:53:22 GMT

Hi Vitish ,

Instead of using pooled tables such as A005, you can use other tables konv where you will get the same data .

Select on pooled tables and Cluster tables hardly uses any indexes which results in solwer select times.

Just try with this hint , hopefully will be useful for you.

Regards,

Nikhil

Re: Performance Issue with table A005

Former Member — Tue, 22 Dec 2009 15:53:44 GMT

This is a pooled table , hence performance issue will be there.

Try to use some alternate table.

Also, a basic tip : check the internal table for initial before using for all entries.