topic Which Select is more efficient in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/which-select-is-more-efficient/m-p/6469841#M1417048 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>Which select is more efficient </P><P></P><P>1) select * from MARA into it_mara where matnr between '00112' and '00114'.</P><P></P><P>or</P><P></P><P>2) select * from MARA into it_mara where matnr in ( '00112' , '0011' , '00113'. , '00114' ).</P><P></P><P>Sandeep</P></BODY></HTML> Mon, 21 Dec 2009 12:27:56 GMT Former Member 2009-12-21T12:27:56Z Which Select is more efficient https://community.sap.com/t5/application-development-and-automation-discussions/which-select-is-more-efficient/m-p/6469841#M1417048 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>Which select is more efficient </P><P></P><P>1) select * from MARA into it_mara where matnr between '00112' and '00114'.</P><P></P><P>or</P><P></P><P>2) select * from MARA into it_mara where matnr in ( '00112' , '0011' , '00113'. , '00114' ).</P><P></P><P>Sandeep</P></BODY></HTML> Mon, 21 Dec 2009 12:27:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/which-select-is-more-efficient/m-p/6469841#M1417048 Former Member 2009-12-21T12:27:56Z Re: Which Select is more efficient https://community.sap.com/t5/application-development-and-automation-discussions/which-select-is-more-efficient/m-p/6469842#M1417049 <HTML><HEAD></HEAD><BODY><P>Doesn't matter, they might produce two different results, depending on what actually is stored in MARA.</P><P>Oh wait, I'm not supposed to reply anyway, this is Subin's job, right?</P><P>Thomas</P></BODY></HTML> Mon, 21 Dec 2009 12:34:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/which-select-is-more-efficient/m-p/6469842#M1417049 ThomasZloch 2009-12-21T12:34:48Z