Performance For Select Query

[Former Member]

Hi,

User want from Date and Plant (Site) wise data only in below select.
Only ERDAT and WERKS satisfy in SELECTstmet. VBELN is blank.
For 1 month range its picking 15000 records.

How to improve its Performance ?

 SELECT vbeln
               erdat
                lfart
                lfdat
                bolnr
                traty
                traid
               bldat
               wadat_is
           FROM likp
           INTO TABLE itab_likp
           WHERE vbeln IN s_vbeln
             AND erdat IN s_dat01
             AND lfart IN s_lfart
             AND vstel IN s_lifnr
             AND werks IN s_werks.

[Former Member]

Hi Jim,

For this query you have to create Index in Likp table .

Go to SE11->LIKP->INDEXES->Create->by Y or Z

then give filelds name as ERDAT and WERKS.

and the write same query then see. how much time it is taking!!!

[Former Member]

hi ,

to improve performance use secondour index it will improve the performance by 100%.

regards,

Prakash

[Former Member]

hi,

use %_hints oracle 'INDEX("Table_name"Table_name~Index_name "")' in ur select query after creating secondory index.

regards,

Prakash

[Former Member]

Without Creating Secondary index .

or using by pass buffer or Packet size will it improve..