When a record is deleted in Vertica, it is not actually deleted per say. Instead it is 'marked' for deletion, and then every once in a while you can purge this deleted data (vertica recommends you do this when deleted data exceeds 10% of the total database size).

You can do this through database designer, by selecting the appropriate optimization. Or if you want further customized projections you can just use their pre-made projection files to help you make new ones then just run the sql scripts. For example: CREATE PROJECTION public.customer_dimension_my_pr...