topic SELECT-OPTIONS 'EQ' vs. 'BT' performance issue in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-options-eq-vs-bt-performance-issue/m-p/2454356#M550228 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I have a query which uses select-options feature for a date range...</P><P>If we give a single date, the report runs instantly but if we use the date range it takes forever to get the reports even though both the low and high dates are the same....</P><P>We had informix earlier and it ran smoothly but now that we are on Oracle we are seeing this issue....</P><P>I am just trying to understand the performance issues with using the 'BT' clause compared to the 'EQ' clause...</P><P>Any inputs are appreaciated...</P><P></P><P>Thanks</P></BODY></HTML> Thu, 28 Jun 2007 14:48:04 GMT Former Member 2007-06-28T14:48:04Z SELECT-OPTIONS 'EQ' vs. 'BT' performance issue https://community.sap.com/t5/application-development-and-automation-discussions/select-options-eq-vs-bt-performance-issue/m-p/2454356#M550228 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I have a query which uses select-options feature for a date range...</P><P>If we give a single date, the report runs instantly but if we use the date range it takes forever to get the reports even though both the low and high dates are the same....</P><P>We had informix earlier and it ran smoothly but now that we are on Oracle we are seeing this issue....</P><P>I am just trying to understand the performance issues with using the 'BT' clause compared to the 'EQ' clause...</P><P>Any inputs are appreaciated...</P><P></P><P>Thanks</P></BODY></HTML> Thu, 28 Jun 2007 14:48:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-options-eq-vs-bt-performance-issue/m-p/2454356#M550228 Former Member 2007-06-28T14:48:04Z Re: SELECT-OPTIONS 'EQ' vs. 'BT' performance issue https://community.sap.com/t5/application-development-and-automation-discussions/select-options-eq-vs-bt-performance-issue/m-p/2454357#M550229 <HTML><HEAD></HEAD><BODY><P>Run the SELECT both ways (with high and low date the same for the second one), and in ST05, do a performance trace on each. Then use the 'explain' function to see if both are using the index.</P><P></P><P>Rob</P></BODY></HTML> Thu, 28 Jun 2007 14:59:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-options-eq-vs-bt-performance-issue/m-p/2454357#M550229 Former Member 2007-06-28T14:59:31Z