Tips for creating include indexes

  • Clustered indexes cannot have include columns. DWD will return an error message is you select a clustered property for an index created with include columns.

  • The same column cannot be in both Select Index Columns and Selected Include columns. The available column will be disabled once it's applied to either the include or index column.