topic Re: Performance For Select Query in Application Development and Automation Discussions

Performance For Select Query

Former Member — Sat, 04 Jul 2009 09:33:20 GMT

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.

Re: Performance For Select Query

Former Member — Sat, 04 Jul 2009 09:55:04 GMT

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!!!

Re: Performance For Select Query

Former Member — Sat, 04 Jul 2009 09:57:51 GMT

hi ,

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

regards,

Prakash

Re: Performance For Select Query

Former Member — Sat, 04 Jul 2009 10:03:39 GMT

hi,

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

regards,

Prakash

Re: Performance For Select Query

Former Member — Sat, 04 Jul 2009 10:06:00 GMT

Without Creating Secondary index .

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