Subject RE: [firebird-support] clarification requested
Author Svein Erling Tysvær
>I wrote the view in the first place because the data is too complicated
>for me to get the data required back in a single query.

Hi Dayna!

Firebird has to combine the view and query to produce an output set and it has to do it only when you ask for your output set. Hence, Firebird has to do what you say is too complicated for you to do. Is this bad? Well, not necessarily, but 'too complicated for me' is not the best reason I've heard for using a view and may indicate that you do things in a suboptimal way (it may or may not be sensible to use a view in your case, you simply haven't told us enough to give you any good advice). So show us the query, view definition, plan and some information about your table(s).