Performance Issue with table A005

[former_member239066]

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.

[Former Member]

Hi

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.

[Former Member]

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

[Former Member]

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.