snippetMinor
How to tell if an index has OPTIMIZE_FOR_SEQUENTIAL_KEY turned on?
Viewed 0 times
optimize_for_sequential_keytellhashowindexturned
Problem
SQL Server 2019 brings the
But how do you check if the option is already turned on for a given index?
And is it on by default in Server 2019? Or Azure?
OPTIMIZE_FOR_SEQUENTIAL_KEY option that, as far as I know you specify on index creation or alter using the WITH keyword.But how do you check if the option is already turned on for a given index?
And is it on by default in Server 2019? Or Azure?
Solution
The system view sys.indexes has a
It is not on by default because it is intended for use only where significant last-page contention is observed.
See Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY for more details.
bit column named optimize_for_sequential_key.It is not on by default because it is intended for use only where significant last-page contention is observed.
See Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY for more details.
Context
StackExchange Database Administrators Q#298822, answer score: 9
Revisions (0)
No revisions yet.