Press "Enter" to skip to content

Enabling Optimize for Sequential Key

Erik Darling shows us how to enable the Optimize for Sequential Key setting on an index:

Recently I blogged about last page contention solutions, and one thing I mentioned is that turning on OPTIMIZE_FOR_SEQUENTIAL_KEY doesn’t require you to rebuild an index.  That’s awesome, because a whole lot of changes to indexes require you to rebuild them.

So how exactly do you do that?

Read on to see how.