Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimization of this SQL sentence - Mailing list pgsql-performance

From A. Kretschmer
Subject Re: Optimization of this SQL sentence
Date
Msg-id 20061017094841.GC19268@a-kretschmer.de
Whole thread Raw
In response to Re: Optimization of this SQL sentence  (Ruben Rubio <ruben@rentalia.com>)
List pgsql-performance
Tree view 
am  Tue, dem 17.10.2006, um 11:33:18 +0200 mailte Ruben Rubio folgendes:
> >
> > SELECT max(idcomment)
> >  FROM ficha vf
> >  INNER JOIN comment c ON (vf.idficha=c.idfile AND (idestado=3 OR
> > idestado=4))
> >  WHERE idstatus=3
> >  AND ctype=1

check for indexes on vf.idficha, c.idfile, idstatus and ctype.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-performance by date:

Previous
From: Ruben Rubio
Date:
Subject: Re: Optimization of this SQL sentence
Next
From: Alexander Staubo
Date:
Subject: Re: Optimization of this SQL sentence