Hints for ADABAS

[Former Member]

Hello!

I try to optimize select below by using HINTS. But i get the same execution plan as without hints.

SELECTION:

SELECT plaf~plnum
             plaf~plgrp
             mara~matnr
             makt~maktx
             plaf~gsmng
             plaf~meins
             kbko~gltrs
        FROM kbko join plaf on
          kbko~plnum = plaf~plnum
        join mara on
          plaf~matnr = mara~matnr
        join makt on
          mara~matnr = makt~matnr

        INTO TABLE gtab_data_year
        WHERE plaf~PLSCN = P_PLSCN
          AND plaf~plwrk = p_werks
          AND plaf~plgrp IN gt_plgrp_rn
          AND plaf~paart = gcon_paart
          AND plaf~obart = p_obart
          AND mara~mtart = gcon_mtart
          AND makt~spras = sy-langu
          AND kbko~gstrs IN gt_gstrs_rn
          AND kbko~typkz = gcon_typkz
          %_HINTS ADABAS  'INDEXACCESS ("PLAF~ZI2")'
           ADABAS 'ACCESS = "PLAF"'.

EXECUTION PLAN 1:

COLUMN OR INDEX                STRATEGY                                                                                
MARA~T                         EQUAL CONDITION FOR INDEX               
                                ONLY INDEX ACCESSED                     
 MANDT                               (USED INDEX COLUMN)                
 MTART                               (USED INDEX COLUMN)                
 MANDT                               (USED KEY COLUMN)                  
                                JOIN VIA MULTIPLE KEY COLUMNS           
 MANDT                               (USED KEY COLUMN)                  
 MATNR                               (USED KEY COLUMN)                  
 SPRAS                               (USED KEY COLUMN)                  
 PLAF~1                         JOIN VIA MULTIPLE INDEXED COLUMNS       
 MANDT                               (USED INDEX COLUMN)                
 MATNR                               (USED INDEX COLUMN)                
 PLWRK                               (USED INDEX COLUMN)                
 MANDT                          JOIN VIA KEY RANGE

Execution plan in other system without hints.

EXECUTION PLAN 2:

COLUMN OR INDEX                STRATEGY

PLAF~ZI2                       RANGE CONDITION FOR INDEX
MANDT                               (USED INDEX COLUMN)
PLSCN                               (USED INDEX COLUMN)
PLWRK                               (USED INDEX COLUMN)
PLGRP                               (USED INDEX COLUMN)
MANDT                               (USED KEY COLUMN)
                               JOIN VIA MULTIPLE KEY COLUMNS
MANDT                               (USED KEY COLUMN)
MATNR                               (USED KEY COLUMN)
                               JOIN VIA MULTIPLE KEY COLUMNS
MANDT                               (USED KEY COLUMN)
MATNR                               (USED KEY COLUMN)
SPRAS                               (USED KEY COLUMN)
MANDT                          JOIN VIA KEY RANGE

What hint for selection should i use to get PLAN 2?

[former_member192616]

Hi Timofey,

try to ask there:

i'm not sooo famillar with all Hints for this DB... but there might be

options to enforce the ordering of tables in a join as well

Kind regards,

Hermann