Subject Re: [firebird-support] Is it possible to have a view with parameters?
Author Ann Harrison
On Fri, Apr 1, 2011 at 12:37 AM, PenWin <penwin@...> wrote:
>>> You won't get the benefit of indexes, though. That's what makes the
>>> parametrized views so useful.
>> Where did the idea that procedures don't use indexes come from?
> Indexes on the OUTPUT.

OK, I understand. If you reference a view in a query, then the view
select expression is reevaluated with the conditions from the outer
query. I still don't see why that's an argument for parameterized views.
You can put the parameter into the outer query, can't you?

Good luck,