| 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: | Whole Thread | Raw Message | 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 |