The plan shown will also show you how much of the view definition the query optimizer was able to remove (because it is redundant).
Requesting a "estimated" plan does not involve executing the query, naturally.
Provided that you have permissions, you can do the same data manipulation in views that you can do to a table directly.
The view is a portion of data from the underlying tables.
This may sound simple enough, but some developers have difficulties with the concept.
Because of this, they tend to leave out is a table, so it is named just like any other table.
Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will find out something new from reading it.
is a virtual table, defined by a query, that does not exist until it is invoked by name in an SQL statement.