Re: [SQL] Similar tables, different indexes performance

2004-12-13 Thread Bruno Wolff III
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 COUNT(*) FROM movimento WHERE cd_pessoa = 1; > count > --- >221 > (1

[SQL] Similar tables, different indexes performance

2004-12-13 Thread Alvaro Nunes Melo
Hi, I know that it's not very polite thing re-send a question, but I don't have any idea about why can this be happening. I have two almost identical tables, with equivalent indexes, but their performances are very different. In this case, I'm sending the queries, explains, tables'structures and r