Query on OBBC (Oracle) is slow if use a native (Access) table for selection criteria
Posted on 2011-03-04
I have a query based on several ODBC Oracle tables. When I run it this way and just type criteria into the query grid, it runs fine. If I make a simple form and have the criteria based on that (each one a single value) it also runs fine.
One of my criteria is date. If I just enter the single date onto the query grid or use the form, everything runs fine.
If I have a select table with one field ([SelDate]) and index it and only put 1 date record in the table, in runs unbelievable slow ( 3 - 5 min) as opposed to seconds.
I need to be able to use a selction that could have several values so I need to figure out why it is so SLOW in I introduce and native access table to the query def.