Skip to Content
avatar image
Former Member

Performance for select from view

Hi,

There is a select from a view (for ekko, ekpo, ekbe tables) which taking long time, some times going to dump which trying to fetch 20,00,000 recirds from database view.

view has created because selects are taking long time.

Is there any way to fine tune.

Means which one either view takes long time of any other way to replace view select.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 21, 2007 at 11:35 AM

    There are a few things you should do:

    1. You should make sure that you don't have too many INNER JOINs.

    2. If you use INNER JOIN, don't use it with tables that have a lot of data, like MAKT or MARA.

    3. Limit your SELECT query with as many WHERE statements as you can. The more defined your SELECT is, the more efficient it is.

    If you'll write your full SELECT here I'll try to help you a bit more.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 11:35 AM

    Can u post u r conditions that u have mentioned in a view ...............

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      ekko-mandt = ekpo-mandt

      ekko-ebeln = ekpo-ebeln

      ekko-mandt = ekbe-mandt

      ekko-ebeln = ekbe-ebeln

      ekpo-ebelp = ekbe-ebelp

  • avatar image
    Former Member
    Aug 21, 2007 at 11:35 AM

    Hi kishore,

    Give your selection condition of the view.

    Add comment
    10|10000 characters needed characters exceeded