--- In firebird-support@yahoogroups.com, Damir Tesanovic <tdamir@...>
wrote:

>
> Hi!
> If I just need to retrieve (no inserts...) some data from multiple

tables

> should I create VIEW or Procedure? Which one is faster?
>
> Damir
>

If you are creating dependencies on it by using it inside another
view, stored procedure or trigger, then use a stored procedure. There
is currently no alter view statement which means that you will need to
write a several hundred line script to add a line to the where clause
of it! (talking from experience)

Otherwise, the view will generally give the optimiser a bit more room
to move.

Adam