topic Performance diff in using IN and OR in select query in Application Development and Automation Discussions

Performance diff in using IN and OR in select query

Former Member — Sat, 15 Aug 2009 05:51:38 GMT

Hello

Is there any performance optimization in using IN instead of OR in where clause in a select query ? IF yes how ?

for ex : Select

from

into table

where x IN (a, b , c)

Select

from

into table

where x = a OR

x = b OR

x = c.

Thanks in advance

- Nilesh

Re: Performance diff in using IN and OR in select query

Former Member — Sat, 15 Aug 2009 10:21:04 GMT

Hi,

You can check the performance by writting this code and executing...

with the use of tools : SE30: Run time analysis: This gives the load on database and appl server

ST05: This is SQL trace for abap select queries

You can compare the results and decide which one to go on ur own..

Hope this helps

Regards

Shiva

Re: Performance diff in using IN and OR in select query

Former Member — Sat, 15 Aug 2009 13:47:13 GMT

This message was moderated.

Re: Performance diff in using IN and OR in select query

Former Member — Sat, 15 Aug 2009 13:48:49 GMT

This message was moderated.

Re: Performance diff in using IN and OR in select query

Former Member — Sun, 30 Aug 2009 06:21:45 GMT

Hey thanks AKASH

I got the concept now...but as u said CONCATENATION STRATEGY is used in both these cases.

can u tell me what all other strategies are used in other cases...any documentations any link abt the same ?

so that i can get insights about internal operations of the select/modify / update / modify statemetns ?

awaiting your response.

Thanks in advance

NIlesh

Re: Performance diff in using IN and OR in select query

matt — Sun, 30 Aug 2009 16:00:27 GMT

Akash's posts have been rejected as they were copy pastes of other people's work, which is absolutely forbidden in these forums, as well as being rather dishonest.

matt

Re: Performance diff in using IN and OR in select query

Former Member — Mon, 31 Aug 2009 05:40:02 GMT

Hello

I will be highly obliged if anyone atleast suggest me the links instead of the direct material so as NOT to violate any rules or policies of the forums.

Thanks in advance

Nilesh

Re: Performance diff in using IN and OR in select query

faisalatsap — Mon, 31 Aug 2009 05:51:04 GMT


> Hello
>          I will be highly obliged if anyone atleast suggest  me the links instead of the direct material so as NOT to violate any rules or policies of the forums.
> Thanks in advance
> Nilesh

Hi, Nilesh

Suggesting Link is also against the Rules if some one can find for that link than why you can't search yourself for these helpful links ? so always do Search yourself and don't think from other to provide you Links, Please.

Faisal