>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 ?

Correct, you gain no speed advantage from using a view. And I don't use
views myself. But I think they can be useful if you need to restrict
access. You could have a table where a user is only allowed access to
certain columns or fields. Defining a view and grant access to the view
rather than the table itself is one way to do that.

Another advantage of views could be simplifying complex selects - not
making it execute any faster, but easier to comprehend.

I don't think there is anything you can do with a view that you cannot do
without it.

Set