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