Degree of normalization of the database
How the Optimizer might use the index
Is the table designed as a staging table for batch loading operations?
Is the table designed as a sandbox table to contain rows until an appropriate primary
index can be determined for their permanent table?
Table type indexed