Interesting, I am learning a lot thanks to all you.

Walter.

On Thu, Mar 31, 2011 at 10:49 AM, Ann Harrison <aharrison@...>wrote:

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


[Non-text portions of this message have been removed]