Re: Pointers for stored procedures?

In article <95c06c$5ch$1_at_malakbel.unb.ca>,   "Scott Stonehouse" <scott_at_mphec.ca> wrote:

> If we had the stored procedures looking at a view instead, we would
 only
> have to change the view. We would be using the view as a pointer, or
 an api
> or an interface, depending on whose language you speak. This makes
 sense
> from one perspective, but I suspect it would drastically slow down the
> execution of the procedure.

Why? When optimizer builds a plan it substitutes view definition with sql anyway, right? And if you use bind variables, you wont be even hit by parsing time.

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 20:03:14 CET