PL/SQL select using date and host variable

From: <chany1357_at_my-deja.com>
Date: Sun, 01 Oct 2000 15:13:14 GMT
Message-ID: <8r7ka6$p60$1@nnrp1.deja.com>

The following is giving very slow response on Oracle 8.1.6 running on a large Sun server box (in OPS):

Exec SQL

     .....
     Select * from <table>
     where (@date1 >= :hostvar1
            and @date2 <= hostvar2
              .....
              .... .
            )

....
End

Does anyone have any suggestions to help this type of query run faster?

Thanks!
Y Chan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Oct 01 2000 - 10:13:14 CDT