A materialized view reduces the width (number of columns) of data being scanned in a base table by creating thin version (fewer columns) of the base table that contains a small subset of frequently queried columns.
Sorted, projected, and materialized views (SPM) are views of user data tables (base tables)
that project a subset of the base table’s columns and are sorted on a specific set of the projected
columns.
So if you have a table with 100 columns but a high percentage of your queries need only 10 of those columns, you can create a SPM View which has only those 10 columns, making queries around 10x faster (assuming all the 100 columns are the same size).
Sorted, projected, and materialized views (SPM) are views of user data tables (base tables)
that project a subset of the base table’s columns and are sorted on a specific set of the projected
columns.
So if you have a table with 100 columns but a high percentage of your queries need only 10 of those columns, you can create a SPM View which has only those 10 columns, making queries around 10x faster (assuming all the 100 columns are the same size).
No comments:
Post a Comment