Chris, this should already be pretty fast as it is using a primary key in
its entirety, and as long as the index size remains manageable MySQL will be
able to keep it in memory for fast access.
That said, doing away with the aggregate function might speed things up just
slightly.
You don't care h
On Thu, Aug 21, 2003 at 01:03:16AM +, gord barq wrote:
> I have this query which does a left outer join and it takes forever (like
> half a day). Here are the results of an explain analysis.
>
> mysql> explain SELECT count(searchresult.title) AS number,
> campaigntrack.title, tracknum, track
gord barq wrote:
I have this query which does a left outer join and it takes forever
(like half a day). Here are the results of an explain analysis.
mysql> explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER
JOIN searchresult
