SELECT-OPTIONS 'EQ' vs. 'BT' performance issue

[Former Member]

Hi Experts,

I have a query which uses select-options feature for a date range...

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....

We had informix earlier and it ran smoothly but now that we are on Oracle we are seeing this issue....

I am just trying to understand the performance issues with using the 'BT' clause compared to the 'EQ' clause...

Any inputs are appreaciated...

Thanks

[Former Member]

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.

Rob