Skip to content

SQL Server Index options SortInTempDB and DataCompression #30408

@hmajerus

Description

@hmajerus

I want to be able to use Fluent API to specify more index options. I have a particular interest in SORT_IN_TEMPDB and DATA_COMPRESSION.

Want something like:

indexBuilder.IsSortedInTempDb(true);

indexBuilder.HasDataCompression(DataCompression.Page);

This can be done by following the pattern set by the fill factor option - #20634.

SORT_IN_TEMPDB can be ON or OFF
DATA_COMPRESSION has the options NONE, ROW, and PAGE (link)

I could work this if determined it would be a good first issue.

Metadata

Metadata

Assignees

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions