At 11:12 AM 21/11/2002 +0100, Roel Rozendaal - IC&S wrote:
We encountered this problem using version 7.2.3; i just checked on my mac
and version 7.2.1 has the same EXPLAIN output.
I'm still trying to understand this behaviour. Has the messageblks table
been vacuumed recently? In the case of the database on your mac, it may be
just a copy loaded from a dump, in which case vacuum is not necesary...
[Reason is ask: One possible cause of this problem is a table *file* that
is very large and full of unused space. The optimizer does a very bad job
in this case].
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
