Re: Very long "or" where clause

Scara Maccai wrote:
> Hi,
> from a table with 100,000,000 rows I have to sum some records using a
> query like:
>
> select sum(field1) from mytab where
>  (time = 1 and id = 3)
> or
>  (time = 3 and id = 1)
> or
>  (time = 2 and id = 5)
>
> The "or clauses" can be even 10,000,000...
> Which would be the best method to access data? Should I use a procedure
> on the server side?

Put the test-values into a temporary table, analyse it and then join
against it. Can't say about indexes without knowing more about your
usage pattern.

--
   Richard Huxton
   Archonet Ltd