SQL Server 2019 brings the
OPTIMIZE_FOR_SEQUENTIAL_KEY option that, as far as I know you specify on index creation or alter using 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?