Skip site navigation (1) Skip section navigation (2)

Re: Optimizar Vista

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: Raúl Andrés Duque <ra_duque(at)yahoo(dot)com(dot)mx>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Optimizar Vista
Date: 2007-04-28 04:14:34
Message-ID: c2d9e70e0704272114k6282f466q3f7511e66d6a6d16@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
On 4/27/07, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
>
> Para saber si realmente los índices te sirven o no, haces esto sin tener
> el índice:
>
> -- esto te entrega el resultado sin índice
> EXPLAIN ANALYZE SELECT ...
> BEGIN;
> CREATE INDEX foobar ON ...
> -- repites el select de arriba y ahora te da el resultado con índice
> EXPLAIN ANALYZE SELECT ...
>
> COMMIT/ROLLBACK
>

no deberia haber un ANALYZE tabla despues del CREATE INDEX?

-- 
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

In response to

pgsql-es-ayuda by date

Next:From: Jaime CasanovaDate: 2007-04-28 04:30:33
Subject: Re: Union
Previous:From: Victor LopezDate: 2007-04-28 04:00:13
Subject: Re: Union

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group