What is the difference between `MAX(column + 1)` and `MAX(column) + 1` I know I should be writing MAX(column) + 1 in my queries rather than MAX(column +1). However, by mistake I wrote the wrong one and it seems to prevent a deadlock issue that I was having. 

Couldn't find an explanation on this after digging for sometimes. Do point me to the write direction if this is already answered or looking forward to learn some new interesting things.
max(column)+1 will compute max value of the column and then adds 1 to the results
max(column+1) will compute max value on column value+1

Tables meta data/index will be used when you use max(column) but max(column+1) needs to scan all the rows and compute the values one by one. So good to use max(column)+1