On Tue, 10 Feb 2004, CSN wrote:
> > So, can you get rid of the join / in on the other
> > table, or do you need it there?
>
> No - each product can fall under multiple categories,
> so I need the product_categories table (and the join
> on it).
Oh, ok. then we might have as efficient a query as we're gonna get.
Oh, another thing is to make your select in the in() clause a select
distinct and see if that helps. If you've got a whole bunch of duplicates
running around in it it's sometimes faster to distinct it. Then again,
given all the work Tom's been putting in the query planner / optimization,
he may have already done something like that.