Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL query using dates and host variables - slow response
Question: are any of the date columns indexed? If they aren't indexed Oracle will perform a full table scan.
Hth,
Sybrand Bakker, Oracle DBA
<chany1357_at_my-deja.com> wrote in message news:8r7lun$qcc$1_at_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 - 15:11:12 CDT