Skip to Content
0
Former Member
Jun 28, 2007 at 02:48 PM

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

526 Views

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