Views on Views

I'm looking for pros and cons of using views.

Suppose I create a complex view on a large table.

Then I issue a statement like:

	select * from newview
  	where field1 = XXXX

Does the server first execute the statement in the view against the entire table then perform the second select statement which might limit the number of rows dramatically or is the server smart enough to limit the rows first then perform the functions in the view only on the limited result set.

-- 
John Parrott
Elysium Financial Systems
spo_at_interlog.com
http://www.interlog.com/~spo