Re: Explain Plan question

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Mon, 22 Apr 2002 15:29:47 GMT
Message-ID: <3CC42C5C.90701AEF@exesolutions.com>

Could you post the three queries with the associated costs?

Daniel Morgan

Jayne Heger wrote:

> Hi,
>
> I have ran an Explain query on three quesries to test which one would be
> the most efficient to use.
>
> The 1st query, had a cost of 26
> second one = 10006
> third one = 7347
>
> Now, to my understanding, the 1st one would be the most efficient.
> But I have also ran a timer on each of the queries, and the 1st query took
> the longest time by far.
> 1st query = 00:11:58:39
> 2nd query = 00:00:08:42
> 3rd query = 00:00:08:80
>
> would it be because of the network load that the 1st query took so long?
>
> Can anyone explain this, i am a bit puzzled?
>
> Thanks
>
> Jayne
Received on Mon Apr 22 2002 - 10:29:47 CDT