topic Re: SELECT statement with 'IN' in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-statement-with-in/m-p/7319785#M1536736 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="red" __jive_macro_name="color">Moderator message - Please search before asking - post locked Rob</SPAN></P></BODY></HTML> Thu, 09 Sep 2010 16:56:04 GMT Former Member 2010-09-09T16:56:04Z SELECT statement with 'IN' https://community.sap.com/t5/application-development-and-automation-discussions/select-statement-with-in/m-p/7319784#M1536735 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If SELECT statement has IN in the where clause, does that use the index?</P><P></P><P></P><P>For example,</P><P></P><P>SELECT t1 f2 f4 from ztest</P><P>WHERE</P><P> fid IN s_id AND</P><P> doctype IN s_doctype AND</P><P> year IN s_year .</P><P></P><P>What is the other option to optimize the SELECT with IN?</P><P></P><P>Thanks &amp; regards,</P><P>Yogita</P></BODY></HTML> Thu, 09 Sep 2010 16:24:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-statement-with-in/m-p/7319784#M1536735 Former Member 2010-09-09T16:24:40Z Re: SELECT statement with 'IN' https://community.sap.com/t5/application-development-and-automation-discussions/select-statement-with-in/m-p/7319785#M1536736 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="red" __jive_macro_name="color">Moderator message - Please search before asking - post locked Rob</SPAN></P></BODY></HTML> Thu, 09 Sep 2010 16:56:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-statement-with-in/m-p/7319785#M1536736 Former Member 2010-09-09T16:56:04Z