Preserving Optimized Projections Across Drop Table Statements
We sync a vertica cluster with tables from mysql daily by dropping the tables and reloading them into vertica. To optimize our vertica queries, we run db designer to tailor projections to our query needs.
However, when we drop/reload tables daily, we will have to re-run db designer?
Is there a way to 'preserve' the db designer 'strategy' so that when we drop / rebuild / reload a table it uses the same projections as before?