On Tue, 14 Sep 2004, Robert Davis wrote:
> I'm trying to benchmark some complex sql queries. One query, in
> particular, is causing problems -- its cost values can vary from 228
> to 907, its Total Runtimes from 60 ms to 5176 ms. The query plans
> show that the optimizer is choosing different pl
ssage-
From: Robert Davis [mailto:[EMAIL PROTECTED]
Sent: Tue 9/14/2004 6:21 PM
To: [EMAIL PROTECTED]
Cc:
Subject: [SQL] explain analyze results are different for each iteration
I'm trying to benchmark some complex sql queries. One query, in
particular, is causing probl
I'm trying to benchmark some complex sql queries. One query, in
particular, is causing problems -- its cost values can vary from 228
to 907, its Total Runtimes from 60 ms to 5176 ms. The query plans
show that the optimizer is choosing different plans for different
iterations of the same query
