Skip to Content
avatar image
Former Member

BW table being read very slowly

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 18, 2016 at 10:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2016 at 08:17 AM

    Hi,

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

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded