Dear Tom,
thanks for your information.
Where can I learn more about the explain and analyze??
One view that is giving a lot of problems is vkardex_3
which is used most of the time...
The explain analyze I sent is one of the views that
conform this one.
Thanks in advance.
Carlos Lopez Linares
---
Carlos Lopez <[EMAIL PROTECTED]> writes:
> This is one of the queries that work,and is the first
> in a 4 level nested query
Do you really need UNION (as opposed to UNION ALL) in this query?
The EXPLAIN shows that almost half the runtime is going into the
sort/uniq to eliminate duplicates ...
This is one of the queries that work,and is the first
in a 4 level nested query
where do I find how to interpret explains???
thanks in advance,
Carlos.
mate=# explain analyze select * from vdocinvdpre;