Hi, I should state that I use 7.4beta1 under FreeBSD -current. On Thu, 21 Aug 2003, mike wrote:
> Date: Thu, 21 Aug 2003 18:28:53 +0200 (CEST) > From: mike <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: index not used afer VACUUM ANALYZE > > Hi, > I hav a db as specified in nit.sql > flows has 763488 entries. > > After dropping/creating/loading the db and running auswert.sh I get > the attached result from query1.txt. > After 'VACUUM ANALYZE' I get the results from query2.txt > > As you can see, the indexes are not used any longer. > Why? > > Bye/2 > --- > Michael Reifenberger, Business Unit Manager SAP-Basis, Plaut Consulting > Comp: [EMAIL PROTECTED] | Priv: [EMAIL PROTECTED] > http://www.plaut.de | http://www.Reifenberger.com > Bye/2 --- Michael Reifenberger, Business Unit Manager SAP-Basis, Plaut Consulting Comp: [EMAIL PROTECTED] | Priv: [EMAIL PROTECTED] http://www.plaut.de | http://www.Reifenberger.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
