Fernando,
1. Try EXPLAIN ANALYZE. Cost alone isn't an absolute measure. I think it's
only to see which parts of the query are expected to be slowest. However,
EXP ANA will give you exact times in msec (which effectively means it
executes the query).
2. I think calling upper() for each row costs
-Mensaje original-
De: SZUCS Gábor [mailto:[EMAIL PROTECTED]
Enviado el: jueves, 26 de junio de 2003 7:31
Para: [EMAIL PROTECTED]
Asunto: Re: [PERFORM] Similar querys, better execution time
on worst execution plan
Fernando,
1. Try EXPLAIN ANALYZE. Cost alone isn't