Re: [SQL] 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution

2007-09-05 Thread Aleksandr Vinokurov
Sorry, just noticed that both query plans are actually for the 8.0.13 release. This one is right: "Total runtime: 93866.526 ms" Any suggestions? Please. Aleksandr Vinokurov wrote: Both plans with queries echoed are attached to this email. Timing is on. explain analyze select log_rec

[SQL] 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution

2007-09-04 Thread Aleksandr Vinokurov
Hello all, I beg your pardon if I do not know some thing, but I was disappointed after taken an upgrade from 8.0.1 to 8.0.13, now the query, that I had optimized so far to run for 92 sec on 8.0.1, takes 106 seconds on 8.0.13. The plan seems to stay unmodified, except statistics used for its