Databases Reference
In-Depth Information
How it works...
The execution plan and statistics of the first query execution are as shown in the following
screenshot:
We can see that in the execution plan, there is full table access to the
SALES
table examining
918K rows and reading 8075 KB. In the statistics, we can see that there are 41549 physical
reads with 41622 consistent gets, because the data wasn't in the buffer cache before the
execution of the query.
The following is the execution plan and statistics for the last query using the materialized view:
