Oups ! Sorry I misunderstanding the command .. always thought it was
almos instantaneous my mistake.. really sorry about that
Thanks :-)
/David
Sean Davis wrote:
- Original Message - From: "David Gagnon" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, June 29, 2005 9:25 AM
Subject:
David Gagnon <[EMAIL PROTECTED]> writes:
> Hi all,
>
> I stop the following statement after 3 minutes
>
>explain analyse select *
> From IC
> where IC.ICNUM NOT IN (select IRICNUM from IR WHERE IRSTATUT
> in (1, 2))
>
>
> I'm using 8.0.3 on windows.
>
> Is that a
On Wed, Jun 29, 2005 at 09:25:24AM -0400, David Gagnon wrote:
>
> I stop the following statement after 3 minutes
>
> explain analyse select *
>From IC
>where IC.ICNUM NOT IN (select IRICNUM from IR WHERE IRSTATUT in
> (1, 2))
What does EXPLAIN without ANALYZE show? What
- Original Message -
From: "David Gagnon" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, June 29, 2005 9:25 AM
Subject: [GENERAL] Explain Analyse never returns .. maybe a bug
Hi all,
I stop the following statement after 3 minutes
explain analyse select *
From IC
whe
