Re: RV: bad result in a query!! hopeless

-----Mensaje original-----
De: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]En nombre de Richard Huxton
Enviado el: miércoles, 16 de octubre de 2002 15:14
Para: Jose Antonio Leo
CC: pgsql-general
Asunto: Re: [GENERAL] RV: bad result in a query!! hopeless

>Because it will have to check the index 75,000 times and then fetch that
>many records from the table. That means it's probably going to read all
>the disk-blocks anyway, so the index is just complicating things.
ok


>You might find a partial index helps a little on the descriptions, but
>it won,t do much. See the docs on CREATE INDEX .... WHERE

You thinks is better a partial index or a view or both?


Jose antonio Leo