Hello, Many thanks for your suggestions. I am trying to optimize server configs, as (presumed) my friend already optimized his queries and firebird windows is executing them fast. You could see at the new attached file the results of the queries rewrite. Unfortunately, the first query simply returned the same estimated costs by the planner. The second one, using EXISTS, multiplied its cost almost 200 times! "Exists" is painfully slow. The shared_buffers was reduced again. Do you have any suggestions? Many thanks. Andre Felipe Machado
sql_query_rewrite.txt.tar.gz
Description: GNU Zip compressed data
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly