The explain result (product of rows) is less than 200,000. I'll include it here, but
I don't know if it's readable or not:
++++---+-+--+---+--
Dear Sir,
AFAICS your query does a FULL join of tables "badge_history, badge,
badgests, department, area" AND an additional LEFT JOIN. Even with indexes
the product may be too big for large tables. What says EXPLAIN SELECT?
Thomas Spahni
On Thu, 7 Jun 2001 [EMAIL PROTECTED] wrote:
> Dear Sirs
On Thu, Jun 07, 2001 at 06:43:01PM +, [EMAIL PROTECTED] wrote:
> Dear Sirs,
>
> We have a very large database (badge_history has > 4,000,000 rows)
> and the explain for our query looks like this:
Like what?
> By using indexes for a query, the product of the row estimates from
> an explain s
Dear Sirs,
We have a very large database (badge_history has > 4,000,000 rows) and the
explain for our query looks like this:
By using indexes for a query, the product of the row estimates from an
explain statement are less than 200,000. The problem is that this query
times out. There is only
