Amazon Redshift announced Multidimensional Data Layout, a powerful new table sorting mechanism that improves performance for repetitive queries. Unlike traditional sorting methods that sort data based on one or more table columns, multidimensional data layouts sort data based on incoming query filters (for example, sales in a particular region), so you can sort data based on one or more table columns. Scan performance is significantly faster. AWS internal benchmark tests show that MDDL reduces total execution time by 74% compared to no sort key and by 40% compared to the best single column sort key. I am.
Amazon Redshift provides an Automatic Table Optimization (ATO) feature that automatically optimizes table design by applying sort and distribution keys without requiring administrator intervention. When you enable ATO or configure a table with SORTKEY AUTO, Amazon Redshift analyzes your query history and selects either a single-column sort key or a multidimensional data layout for your table, depending on which option is more appropriate for your workload. will be automatically selected.
Multidimensional data layouts are available as a preview in the following AWS Regions: Asia Pacific (Tokyo), US East (Ohio), US East (N. Virginia), US West (Oregon), Europe (Ireland), and Europe (Stockholm). ). For more information, see the Amazon Redshift Database Developer Guide and blog.
