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