Forum Discussion

JoyH's avatar
JoyH
Icon for Helper I rankHelper I
4 years ago

Incremental Refresh - historical data updates

Hi! One of our tables has 80M rows. Each row contains the insert_dtm (the datetime the row was created) and update_dtm (the datetime the row was last updated). During the incremental refresh, we n...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi JoyH ,

 

I think you can not optimize it, because each month partition must be checked for updates.