Re: INFORMIX views

In article <2ko58dINNm19@emory.mathcs.emory.edu> peepinged@aol.com writes: :A co-worker and I were discussing how INFORMIX handles a view on a table. I :was under the impression that when you select off a view, INFORMIX merges the :view criteria (ie, the WHERE clause) with your criteria and then executes the :result. Therefore, if your criteria contained a GROUP BY clause, INFORMIX :would merge the view criteria with your statement and execute the result as a :single SELECT. : :My co-worker thinks that INFORMIX will first select the rows fitting the view :being used and then perform your SELECT against the resulting temporary :table. You are correct; the merge of conditions occurs in the optimizer. Your co-worker is wrong. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney