topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Fri, 14 Mar 2008 04:45:22 GMT

Dear all

I have a doubt in Select query while using INDEXES.My index name is 'B' and in that index the field order is like

Matnr

Werks

lgort...

Suppose in my 'Where Clause' i am just giving like

where werks in s_werks and

lgort in s_lgort... i mean i am avoiding the first field of the index.

i want to know in this cause it will follow the index or it will bypass.

Please help me....

Re: Select Query

Former Member — Fri, 14 Mar 2008 04:50:16 GMT

Hi,

No problem . It will follow the index.In where class if it is in order the performance will be more.

If in order checking of the fields will be in order .So cursor will move ahead.If disorder the cusrsor will move fornt for one field and come back for other field.So poor performance.....

Re: Select Query

Former Member — Fri, 14 Mar 2008 04:53:27 GMT

Hi,

There wont be any problem while selecting records. But, u will end up in performance error when u do code inspector check.

Reward if helpful.

Regards,

Ramya

Re: Select Query

Former Member — Fri, 14 Mar 2008 04:56:55 GMT

Thanks Murali.. And one more thig is, is there any change in the case of MANDT field.. I mean in the index if the first field is 'MANDT' is there any change.. please tell that also..

thanks

Re: Select Query

Former Member — Fri, 14 Mar 2008 04:59:22 GMT

Hi,

No change.MANDT field should always be in first position.

Re: Select Query

Former Member — Fri, 14 Mar 2008 05:03:07 GMT

Hi Murali

Thanks a lot for quick reply.. But plz understand my Qn.. if the field order in the INDEX is like

MANDT

Matnr

werks... at this moment can i use

where matnr in s_matnr

and werks in s_werks...

whether it will follow the index or nor. Or it is necessary that i should write the MANDT at first to follow the index... that is my question... plz answer this also..

thanks..

Re: Select Query

Former Member — Fri, 14 Mar 2008 05:10:17 GMT

Hi,

No need to write MANDT in where condition.Because by default selection statement will select the records of login client only you can not select the other clients.If you want to select other client data you have to write syntax in seletion statement

SELECT *

INTO table itab

FROM table name CLIENT SPECIFIED

WHERE mandt = '000'.

Pls. reward if useful.....