Amazon Redshift announces Multidimensional Data Layouts, a new powerful table sorting mechanism that improves performance of repetitive queries. Unlike traditional sorting methods that sort data based on one or more table columns, Multidimensional Data Layouts sorts data based on the incoming query filters (for example: Sales in a specific region) , which significantly accelerates the performance of table scans. An AWS internal benchmark test shows that MDDL produced a 74% total runtime reduction compared to having no sort key, and a 40% total runtime reduction compared to the best single-column sort key.
Source:: Amazon AWS