WHY SQL-Statement without bind-prameters runs 50 times faster as with ??????

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 2000/05/03
Message-ID: <mxILOlCKIAE5Ew7d@ahardy.demon.co.uk>#1/1

In article <24b2b424.c4731a9d_at_usw-ex0105-034.remarq.com>, Karl R. <kreitsch_at_zdnetonebox.com> writes
>ORACLE 7.3.4.1, AIX, PRO*C 2.2
>
>WHY SQL-Statement without bind-prameters runs 50 times faster
>as with ??????
>The index ist used in both cases! Is this prbably a problem of
>the to_date-Function ?

Yes, using the to_date function causes Oracle to perform full table scans.

Can you convert the dates before calling the SQL statement?

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================

Received on Wed May 03 2000 - 00:00:00 CDT