View mechanism

Hi

If I make an select with a WHERE clause upon a view, how it behaves? (1)It will merge my WHERE clause with the view's where clause and execute the view or (2)will execute the view and then execute my where clause over the result set returned by the view? I think the answer is (2), because the poor performance. This behaviour can be changed via some server setting, or there is another way?

Thank you
Luis Cabral

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 12 1998 - 11:10:19 CST