Thread

Problem with complexer join still persists sometimes

Michael Reifenberger <root@nihil.plaut.de> — 1999-03-31T09:37:08Z

Hi,
I still have a problem with one query not returning all matching queries.
But it get's better than a few weeks before :-)
The symptom now:
As long as I do NOT create statisics wit 'VACUUM ANALYZE' I get all matching
queries. After the first 'VACCUM ANALYZE' the query malfunctions.

As a attachment: a.txt a EXPLAIN SELECT before the VACUUM,
  b.txt a EXPLAIN SELECT after the VACUUM.

For the used queries please search my last mail to hackers..

Bye!
----
Michael Reifenberger
Plaut Software GmbH, R/3 Basis