Figure 1 shows what that execution plan might look like.Figure 1: A nonindexed view accesses the base tables when querying the view. Neither source table is indexed so the database engine performs table scans to retrieve the data.
You cannot, for example, use the getdate() function in the query because the value returned is always different.
In addition, you must always include the WITH SCHEMABINDING clause in your view definition.
Suddenly, without noticing, the no value case is not handled anymore.
As a result, you might sometimes get fatal PHP errors telling you that you called a method on a non-object; users might see blank pages, or worse.
Figure 2: An indexed view does not access the base tables when the view is queried.