Options
Query performance
lucylinie21
Vertica Customer
Table has day, campaign_id and various data columns.
If the table has NULL value in data columns, does that effect on query performance/speed,( like query need to filter on campaign_id in last n days) ? Tweakbox
0
Answers
@lucylinie21 There should be no impact on performance however if segmented clause on null column then all the null value will be accumulating on one node as hash of null is same always and that will have impact only on storage skewness. If you query for the null data then yes you see the impact on performance.