Explain Analyze understanding

Hi,

I need to improve performance for a particular SQL command but facing difficulties to understand the explain results.

Is there somewhere a tool could help on this?

I've stored the SQL code and corresponding explain analyze at

SQL: http://www.opendb.com.br/v1/sql.txt
Explain: http://www.opendb.com.br/v1/explain.txt

in case some one could identify some improvement that could be done to the SQL or table structures in order to get better command performance.

Thank you!

--
Reimer
47-3347-1724 47-9183-0547 msn: carlos.reimer@opendb.com.br