| From: | "Mario Gonzalez ( mario__ )" <gonzalemario(at)gmail(dot)com> |
|---|---|
| To: | "ricardo yanguma" <ricardo(dot)yanguma(at)gmail(dot)com> |
| Cc: | Postgres Español <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: servidor |
| Date: | 2006-10-12 21:18:01 |
| Message-ID: | 2065a6cf0610121418j2abf1114u72270b1821152d72@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
On 12/10/06, ricardo yanguma <ricardo(dot)yanguma(at)gmail(dot)com> wrote:
>
> Index Scan using nr_tcarga_codfac on nr_tmp_carga (cost=0.00..4.61 rows=1
> width=830) (actual time=0.451..0.451 rows=0 loops=1)
> Index Cond: ((nr_codfac >= 1) AND (nr_codfac <= 1))
> Filter: ((nr_codsubs >= 1) AND (nr_codsubs <= 1) AND (nr_codran >= 1) AND
> (nr_codran <= 1))
> Total runtime: 0.855 ms
>
mmhh, no la cheque muy bien per creo que Alvaro escribio tu consulta
de una forma mas simple y rapida de ejecutar.
Ahora, despues que creaste los indices (que no tengo idea cuales
fueron, \d seria bueno) la consulta sigue demorandose tanto?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ricardo yanguma | 2006-10-12 21:23:16 | Re: servidor |
| Previous Message | ricardo yanguma | 2006-10-12 21:06:59 | Re: servidor |