From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
---|---|
To: | Figo's <figo_sistemas(at)yahoo(dot)es> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: - - Problema con ídices . |
Date: | 2006-02-21 00:38:37 |
Message-ID: | c2d9e70e0602201638l16de4741v33852d62ae5a99d8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
> index_tbs_email_temporal_emte_status btree (emte_status)
>
> La consulta:
> explain select * from tsmtp.tbs_email_temporal where emte_status='N'
>
> El Explain:
>
> "Seq Scan on tbs_email_temporal (cost=0.00..24296.38 rows=524754
> width=184)"
> " Filter: (emte_status = 'N'::bpchar)"
>
cuantos valores diferentes puede haber en emte_status? si son menos de
10 con una distribucion mas o menos uniforme probablemente un indice
sea perdida de tiempo...
--
Atentamente,
Jaime Casanova
"What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting the wrong answer really fast."
Randal L. Schwartz
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2006-02-21 00:40:46 | Re: Ayuda sobre fechas |
Previous Message | Juan Martínez | 2006-02-20 22:44:59 | Re: Significado |