Create/alter/drop projection for Vertica in-DB

[simonaubert_bd]

Hello all,

In addition to the create index idea, I think the equivalent for vertica may be also useful.

On vertica, the data is store in those projections, equivalent to index on other database... and a table is linked to those projections. When you query a table, the engine choose the most performant projection to query.

What I suggest : instead of a create index box, a create index/projection box.

Best regards,

Simon

[KylieF]

Thank you for your idea and feedback!

We appreciate all the feedback we get on how we can improve our in-DB tools and database behaviors. If possible be sure to share this idea with anyone who you feel would be impacted as it greatly helps our product team to see the interest in ideas like this.