-
Smart MinMax Index 7 min
- Feedback
-
Take Course Survey 1 min
Smart MinMax Index
During this video we provide a demonstration of how to make use of the new Smart MinMax Index feature introduced with the release of Vector 6.3
|
At the end of this course you will:
|
|
Have gained an understanding for how to implement the Smart MinMax feature provided with the release of Actian Vector 6.3. This feature introduces a smart MinMax index (set by AUTO_TUNE to the WITH Clause), which enables Vector to dynamically choose a current subset of MinMax index columns based on collected statistics. Vector drops unnecessary index columns and adds necessary columns to the MinMax index according to their predicted selectivity, with respect to upcoming filter queries, based on the set of filter queries seen so far. This feature reduces memory utilization, while attempting to maintain run time performance, by eliminating index columns that are rarely queried or do not have a high (predicted) selectivity. |
|
Course Style:
|
|
The content is presented in a how to style in order for you to follow along within your own database environment
|
|
Audience:
|
|
For System or Database Administrators who have responsibility for maintaining and optimizing the Corporate Databases and Data Warehouses.
|
|
Prerequisites:
|
|
Functionality available from Actian Vector 6.3 onwards. |
|
Resource Links:
|
|
Software Download: https://esd.actian.com/
Actian Community: https://communities.actian.com
Documentation: https://docs.actian.com/
|