Sir, LEFT JOINs rule out the use of indices on the join column in the
left table, making LEFT JOINs inherently slow. Try putting indices on
the columns used in your WHERE and ORDER BY clauses. I'm not
promising it will help, but it is recommended in Paul's book.
Bob Hall
Hi folks,
after
Hi folks,
after having carefully tuned all statements within a larger web based
application rewriting SQL statements and optimizing them by adding indices,
there are still two statements left, which are awkward concerning
performance. Maybe I am just too blind to see how to get them working