
Multidimensional clustering (cont.)
With multidimensional clustering, these benefits are extended to more than one dimension or clustering key. In terms of query performance, range queries involving any combination of specified dimensions of the table will benefit from clustering. Not only will these queries access only those pages having records with the correct dimension values, these qualifying pages will be grouped by extents. Although a table with a clustering index can become unclustered over time as space fills up in the table, a multidimensional clustering table is able to maintain its clustering over all dimensions automatically and continuously, thus eliminating the need to reorganize the table to restore the physical order of the data.