Query performance

lucylinie21lucylinie21 Vertica Customer
edited March 2021 in Product Feedback

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


  • Options
    Nimmi_guptaNimmi_gupta - Select Field - Employee

    @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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file