Subject | RE: Re[4]: [Firebird-Architect] ORs in Where statement |
---|---|
Author | Claudio Valderrama C. |
Post date | 2003-07-29T11:46:32Z |
Daniel Rail wrote:
would rather use
select something, udf(whatever)
from ...
instead of putting the udf(whatever) call in the WHERE or JOIN/ON clause.
Furthermore, there's more logic in FB than simply reading records...
remember that there is extra logic involved when indices can be used. Or do
we want a config param to control the creation of sparse bitmaps?
;-)
C.
>Don't know why someone would want to write that call in an OR condition. I
> I think the only side effects possible would be to perform an external
> operation to Firebird(i.e. writing to a text file).
would rather use
select something, udf(whatever)
from ...
instead of putting the udf(whatever) call in the WHERE or JOIN/ON clause.
Furthermore, there's more logic in FB than simply reading records...
remember that there is extra logic involved when indices can be used. Or do
we want a config param to control the creation of sparse bitmaps?
;-)
C.