The Vertica Database Forums

hello,

I have a pre-join projection for a Fact table, with a Dimension table.
I notice that when I update my Dimension table through a Merge statement, the pre-join projection is updated too.
I saw this in the Result of'the Explain on the merge query and also by the fact that dimension update takes a lot of time.
I am not interested in the update of the pre-join projection: the fact inserted before the update can have the old dimension value, important is that the newly inserted fact after the dim update have the new dim values.
Is there a way to prevent the dim update from updating the pre-join projection?

Thanks in advance for any hint,
Br

Are you updating on the join key?

Hi!

[DELETED]

For Norbertk: no, the join key is my dim primary key.
I possibly update other dim columns if dim key already exists or I insert a new dim record if dim key does not exist.