There are two types of views, Standard Materialized Views and Filter Materialized Views. Both views enhance reporting performance. Either one can be optionally applied to a database. See the comments in the scripts for additional information about the functions of each view.
Note: The script names may abbreviate "Materialized" to "Mat", as in: StepX_Define Filter Mat Tables
and Indexes.sql
Standard Materialized Views (SMV) - Converts all the views accessed by reports into tables. This view includes the index to enhance the query execution time. A feature where all the views (which is what the reports access) are converted into tables, and indexes are added to enhance the query speed.
Filtered Materialized Views (FMV) - Converts all the views accessed by reports into tables and requires filters to be applied before the views are converted into tables. The filters are stored in a separate table. For example, if a user selects notepad.exe
as a filter, the FMV table is populated with the notepad details for all the devices. It is similar to SMV, but differs in that it requires filters to be applied at the time the views are converted into tables. The filters are stored in a separate table. As an example, if a filter for Notepad.exe is selected, the FMV table will be populated with only notepad details for all the devices.