Re: [PERFORM] Similar tables, different indexes performance

2004-12-13 Thread Bruno Wolff III
On Mon, Dec 13, 2004 at 17:32:02 -0200, Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote: > Em Seg, 2004-12-13 às 16:03, Bruno Wolff III escreveu: > > On Mon, Dec 13, 2004 at 15:17:49 -0200, > > Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote: > > > db=> SELECT COUNT(*) FROM titulo WHERE cd_pessoa = 1;

Re: [PERFORM] Similar tables, different indexes performance

2004-12-13 Thread Alvaro Nunes Melo
Em Seg, 2004-12-13 às 16:03, Bruno Wolff III escreveu: > On Mon, Dec 13, 2004 at 15:17:49 -0200, > Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote: > > db=> SELECT COUNT(*) FROM titulo WHERE cd_pessoa = 1; > > count > > --- > >220 > > (1 record) > > > > Time: 48,762 ms > > db=> SELECT COUN