Creating an include index for a dimension table

An table index allows you to include columns that are not indexed columns on the index definition. This can eliminate necessary reads to the physical database in transformation process.

Use the instructions in this section to create an include index in a dimension table.