At 06:14 AM 11/26/2004, Carsten Schäfer wrote:

<a lot of stuff including some long unformatted
queries>

Without having reformatted and dug through your
queries, I've got a question and a fact that may be
of interest.

Question, have you checked the plans for the slow
and fast queries? Are they different? What are
the differences?

Fact. The optimizer will choose to use an index
if you have a comparison like 'A > 0', though it
will assign it a low probable selectivity and
will look for other paths. The optimizer will not
use an index for a comparison like 'A <> 0'. You
may know that only a few rows have 'A <> 0', but
the optimizer doesn't.

Regards,


Ann