Re: question on most efficient way to increment a column

[Alban Hertroys <haramrae@xxxxxxxxx>]

On May 8, 2013, at 21:14, Tyson Maly <tvmaly@xxxxxxxxx> wrote:

The simple update is one I considered, but I think if I put it into a stored procedure it should run faster

Well, you would partially circumvent the query planner, but you would also circumvent any optimisation said query planner would be able to do based on the statistics for the values being updated.

Alban Hertroys

--

If you can't see the forest for the trees,

cut the trees and you'll find there is no forest.