Re: where 1=1 ?

Hi,
 I tend to use this kind of stuff for debugging,  that way i can turn (sub-)predicates on or off as i like.

 possibly a leftover from the developer.

 You won't get much of a performance gain by removing this predicate, it just looks a little funny.

Karsten

In article <38D0F3E8.91720670_at_si.unirioja.es>, Julio <julio.negueruela_at_si.unirioja.es> wrote:
> I'm reviewing an application we've bought to an outer company in
 order to (try
> to) optimize some queries they use and I've seen a lot of
 occurrencies of that
> strange clause show above. I.e.:
>
> select empno from emp
> where 1=1 and empdpt='COMPUTER';
>
> Does anybody wich is the utility of introducing such comparison?
>
> Regards.
> --
> Julio Negueruela
>
> 'Hay algunas cosas que son tan serias
> que solo puedes bromear con ellas.' (Bohr)
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 17 2000 - 00:00:00 CST