PL/SQL query using dates and host variables - slow response

From: <chany1357_at_my-deja.com>
Date: Sun, 01 Oct 2000 15:41:11 GMT
Message-ID: <8r7lun$qcc$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:41:11 CDT