Re: Problema SQL

On 2/15/07, Oswaldo Hernández <listas(at)soft-com(dot)es> wrote:
> xx=# select valor
> xx-# from valorescomunes
> xx-# group by valor
> xx-# having count(valor) = (select count(claves.clave) from (select distinct clave from
> valorescomunes) as claves);

el query queda mejor asi, corriendo un explain analyze en ambos veo
que mi version elimina un paso Sort y uno Unique que incluye el plan
del query que pasaste en tablas grandes eso puede hacer la diferencia
:)

select valor
from valorescomunes
group by valor
having count(valor) = (select count(distinct clave) from valorescomunes);

--
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