Skip to Content
0

BW table being read very slowly

Nov 18, 2016 at 05:04 PM

47

avatar image

Hi all,

There is an application reading an BW ODS table (/B1H/ASD_D3400) which has nearly 3 billion entries and although it is reading the table with a full key, it is still very slow. Other similarly large tables were read reasonably quickly compared with this one.

Can anyone give any guidance on how to check and resolve what is happening with this table compared to the others?

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nanda Anantha Nov 18, 2016 at 10:06 PM
0

Hi Isa Beck,

Did you used any WHERE clause in Select query, if yes whatever FIELDS used in WHERE clause should be indexed otherwise reading will be slow.

Regards

Nanda

Share
10 |10000 characters needed characters left characters exceeded
Loed Despuig Nov 23, 2016 at 08:17 AM
0

Hi,

Is this a routine? If yes, can you post your code here so we can check it?

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded