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,

Ann