Hi,
Can't post specifics at the moment but if this seems like a common
problem any help would be appreciated.
When querying with ~6 tables, using mostly left outer joins, I get
standard performance with the where clause
where XXX is not null
however, if I try the clause
where XXX = 4
the query takes upwards of 5-6 minutes (I just stop it running at that
point.
The field XXX is in the 'main' table (to which the joins attach), it's
an integer field too so I can't see too many problems there.
There's no index on the XXX field, but if I remove the joins, I get
standard performance doing either query.
So why would the second query's performance differ so significantly?
Cheers,
Chris