Jean,
I see your point. For the incremental data, which is very small, I should make
sure that the PARTITION BY in the OVER(PARTITION BY ...) is left out so that
all the data will be in one partition when assigned a row number. The query
below should avoid any problems.
“SELECT ROW_NUMBER()
Is there only one process adding rows? because this seems a little risky if you
have multiple threads doing that…
> On Oct 8, 2016, at 1:43 PM, Benjamin Kim wrote:
>
> Mich,
>
> After much searching, I found and am trying to use “SELECT ROW_NUMBER()
> OVER() + b.id_max