> 1. They execute faster. The db (I only know from Oracle and SQL Server, if
> others are different it doesn't really concern me) can optimize the
> execution plan.
Prepared statements have precompiled execution plans as well.
> 3. You can limit access with them. Now granted you can set it up so you are
> only selecting from a view in your query block as well, but it makes more
> sense to me to do it in a procedure.
If possible to enforce the same limitations through them, I
generally prefer an updateable view with check option (I believe
the Oracle marketing department invented the term Virtual Private
Database for what is essentially the same functionality).
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
