[thelist] ASP & SQL

[rudy]

>Indeed.  Except that the expense of OR's is quite high.

quite so

often the optimizer sees ORs and switches right over to table scans rather
than using index merge or whatever

the cost to parse a dynamic query is really slight

i would give odds that total execution time with dynamic queries will be
less than static queries with builtin conditions for every kitchen sink
field, given a good sample of many queries, some with all conditions, some
with only a few


>> (oh, and if NULL values are an option, deal with accordingly)
>
>Yeah, that makes it even uglier.  :-)

i resent the implied disrespect for nulls

or did i just infer it?   ;o)

nulls are glorious

the only people who seem to have problems with nulls are people who don't
know what they're for


rudy