Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: where 1=1 ?
Thomas Kyte wrote:
> Hopefully, the queries you see are really like:
>
> select empno from emp where 1=1 and empdpt=:BV
>
> and not hardcoded as you have. One of the #1 performance killers -- no bind
> variables.
I hoped so but unfortunately it is not as you say. Although I have not the fonts(saw it through the v$sqlarea) the application is developed in C, so I think they concatenate the var value with the query and execute it. :-(
Thanks everybody.
-- Julio Negueruela 'Hay algunas cosas que son tan serias que solo puedes bromear con ellas.' (Bohr)Received on Fri Mar 17 2000 - 00:00:00 CST