Re: [firebird-support] Is it possible to have a view with parameters?
Author
PenWin
Post date
2011-04-01T04:37:24Z
> On Thu, Mar 31, 2011 at 3:04 AM, PenWin<penwin@...> wrote:
>>
>>> create selectable procedure, and You can do all You want.
>>
>> 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? Yes,
Indexes on the OUTPUT.
> in some cases - e.g. LIKE - a statement with a parameter cannot be as
> well optimized as a statement with an actual value, but you can look at
> the plans for stored procedures and see that they do use views, even on
> queries that include parameterized values.