-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 3:14 PM
To: Kapoor, Nishikant
Cc: mysql@lists.mysql.com
Subject: RE: SQL query taking a long time...please
"Kapoor, Nishikant" <[EMAIL PROTECTED]> wrote on 08/02/2005 02:5
"Kapoor, Nishikant" <[EMAIL PROTECTED]> wrote on
08/02/2005 02:58:08 PM:
> Just wondering if someone would be kind enough to take a look at it -
Nishi
>
> > -Original Message-
> > Following query is taking a long time (upto 10 secs) to
> > return the resultset. Would greatly appreciate
At 01:58 PM 8/2/2005, you wrote:
Just wondering if someone would be kind enough to take a look at it - Nishi
Nishi,
What did "EXPLAIN" show? Also what happens if you have just one
Match? Is it faster? If so, why not run 2 queries and build a temporary
table from the results. Using "O
Just wondering if someone would be kind enough to take a look at it - Nishi
> -Original Message-
> Following query is taking a long time (upto 10 secs) to
> return the resultset. Would greatly appreciate if someone
> could help me understand why.
>
> I have run 'analyze table ' on all t
Following query is taking a long time (upto 10 secs) to return the resultset.
Would greatly appreciate if someone could help me understand why.
I have run 'analyze table ' on all the three tables involved. The
EXPLAIN output, record count and table description is also included.
SELECT SQL_CALC_