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

Query performance

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

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.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.