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,
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.

Good luck,

Ann