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!
How to avoid this error message when i make projection?
HyeontaeJu
Vertica Customer ✭
The error message is this
"Delete performance of projection newbiz_product.ws_product_category_map_DBD_1_rep_wshop_prod_map_b1 is a concern. The squared number of rows scanned for each delete is recorded to be 28947035 on average"
0
Answers
Please read the following page for the DELETE and UPDATE Optimization.
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AnalyzingData/Optimizations/OptimizingDELETEsAndUPDATEsForPerformance.htm