• Regular views offer nothing from a performance standpoint. Views are simply replaced by their definition in the query submitted for execution and then optimized as if the query submittor had supplied the entirety of the view-query themselves.

    For example, if I have a view named dbo.SomeData defined as:

    CREATE VIEW dbo.SomeData

    AS

    SELECT ColumnName FROM dbo.SomeTable;

    GO

    and I say

    SELECT * FROM dbo.SomeData;

    this (in general terms) is what the query engine will eventually optimize after view-replacement is done:

    SELECT * FROM (SELECT ColumnName FROM dbo.SomeTable);

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato