Hi Adam!

> I reduced a query from 3 minutes to about 0.5 seconds just last
> week, and all I did was switch around the order of the joins and
> the switched one of them with the from. It reduced the workload
> from 100000 records to about 3 or 4 records.

Statements like this makes me curious. Are you saying that SELECT *
FROM A JOIN B is different from SELECT * FROM B JOIN A? Can you show
us the "good" and "bad" query with their indexes? I'm just puzzled.

Set