Views + Criteria

Hello,

I am designing a complex query that needs to take data from about 10-15
tables.  To break down complexity and
I thought of splitting it into two views that make sense semantically and
use a third one to link them all together.
However, I am specifying my query criteria in the third view (for testing
now I am using constants) and the view
is very slow to open.
To find out what is wrong, I tried the same thing only with the criteria
specified as WHERE clauses in all three
views and the third view opens much faster.  Can anyone answer these
questions please:
1.  Does Postgres run all the joins and then use the criteria to limit the
amount of data?
2.  Is there a way in Postgres to send parameters from a client to the
server that will apply to
all three views?

Thanks.  Just for your info I am using v7.2.1 on linux and I want to use
Access as a client in windows.


Nicolas





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----