Which One of These is Not Like the Others?
Sarah Lemaire, Manager, Vertica Documentation
May 17, 2016
With the new guaranteed uniqueness optimization feature in Vertica 7.2.2, Vertica automatically recognizes when a query is accessing columns with unique values and optimizes the query operations that would otherwise be bogged down due to duplicate values.