The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Projections

Projection Permission and Ownership

abtsantosbenten 6.4K views 12 comments 0 points Most recent by abtsantosbenten July 2019General Discussion
Auto-Projection Column Sort Order

Jim_Knicely 820 views 0 comments 0 points Started by Jim_Knicely July 2019 Tips from the Team
Checking and improving column compression and encoding

Bryan_H 1.5K views 1 comment 1 point Most recent by Sharon_Cutter November 2019Tips from the Team
Example of scenarios to not define a projection?

Answered Min_Yun_Chan 1.1K views 1 comment 0 points Most recent by ybei April 2020General Discussion
User specified segmentation in Live Aggregate Projections?

Answered Min_Yun_Chan 1.7K views 2 comments 0 points Most recent by ChuckB April 2020General Discussion
How do aggregate projections affect the load performance?

Answered Min_Yun_Chan 1.2K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
Eon mode: projections created on ALL NODES or all shards?

Answered DreaBrandford 1.1K views 1 comment 0 points Most recent by Pan April 2020General Discussion
Buddy projections after lowering K-Safety from 2 to 1

Answered robbledobble 1.1K views 1 comment 0 points Most recent by Vertica_Curtis April 2020General Discussion
Can some one explain me this Non privileged users are able to create projections when hints used?

Answered ✓ sahil_kumar 1.6K views 2 comments -1 point Most recent by sahil_kumar June 2020General Discussion
query plan is different between select from table and select from view

sma 1.6K views 2 comments 1 point Most recent by sma July 2020General Discussion
About super projection Optimization

Answered ✓ yamakawa 2K views 3 comments 0 points Most recent by mosheg November 2020General Discussion
Projections Hints

Answered ✓ reli 3.2K views 6 comments 0 points Most recent by reli January 2021General Discussion
Deleting unused projections

Answered ✓ yamakawa 1.2K views 2 comments 0 points Most recent by yamakawa April 2021General Discussion
How has global events in the last two years reshaped predictive analytics?

Answered melroyr 655 views 1 comment 0 points Most recent by mosheg April 2022General Discussion
Optimizing DISTANCE using projections

Answered zun 1.5K views 3 comments 0 points Most recent by Hibiki October 2022General Discussion
SALT in Segmentation Clause

Answered ✓ mferrall 2.1K views 4 comments 0 points Most recent by VValdar August 2022General Discussion
How to expand k-safe / fault tolerance from 0 to 1, i have expand vertica db from 1 to 3 nodes ?

Answered Bilal_raza 1.2K views 2 comments 0 points Most recent by mosheg July 2022General Discussion
How to create a projection when creating a table?

Answered ✓ jiahe1224 2.3K views 10 comments 0 points Most recent by marcothesane January 24General Discussion

Projections

Discussion List