If I have large table with ex. 500milion rows, is adding new column with no value exspensive? Is there some description in documentation about this. Thanks, Josip
We intend that this sort of operation should be fast. So, it's good to have someone else confirm that it actually is :-)
For what it's worth, as a column-store database, it is our design intention that column-level operations such as adding columns should always be cheap, whether you have 500 million rows, 500 billion rows, or even more than that.
Comments
tested on 20TB, Vertica 7
Just say what I did and what I can confirm
Josip
We intend that this sort of operation should be fast. So, it's good to have someone else confirm that it actually is :-)
For what it's worth, as a column-store database, it is our design intention that column-level operations such as adding columns should always be cheap, whether you have 500 million rows, 500 billion rows, or even more than that.
Adam