On 17 Mar 2004 at 10:19, akestion wrote:

>What are the most advantages of Views compare to to store procedure :

Additional conditions can be applied to a view in more effective
way, I suppose.

>Maybe it's a question of efficiency or speed in execution...

If I'm not mistaken, optimizer can use indices from base tables
during execution select from a view. Result set of SP can be accessed
only sequentially.

>So what are the mains uses for views, and are the most advantages ?

For me the main use of view is a transparent security. You can hide
some columns and/or records of table(s) from user and still pretend
that the result is a table.

SY, Dimitry Sibiryakov.