I stopped using views for the reasons you state, but mainly because
it makes the whole database much more inflexible during development.
Any field mentioned in a view cannot be dropped unless you first
change the view, and every time you add a field, you have to think
about whether it needs to be added to views, etc. This makes it very
difficult to use an iterative development process (ie, one where you
have not planned all your tables and structures in detail in
advance).

--- In ib-support@y..., Carsten Schäfer <ca_schaefer@g...> wrote:
> Hi,
> in general i create views to select from columns of different
tables with one select.
> I was thinking that the view is once created and than updated every
time when a underlying table is updated.
> But my tests shows me that there is done a join on the tables
everey time i make a select on the view.
> So there is no difference (in speed) when i use an explicit join in
my select and not using the view.
>
> So why should somebody use a view ?
>
>
> gruse
> Carsten