This option enables you to set the default type of Foreign Key Index Type for each table type.

Foreign Key Index Type

Set the default index types built for foreign key columns of Dimension tables, KPI Fact tables, Fact tables and Aggregate tables.
SQL Server options:

  • (None) - will not be defined
  • Nonclustered Index- this is a standard index per key column
  • COVERING - This is a single index with all the key columns in it
  • COVERING ColumnStore Index

Oracle options:

  • (None) - will not be defined
  • BITMAP - the standard Oracle bitmap index
  • BTREE - this is a standard index per key column

These defaults are applied when an index definition is created.
They can be changed by selecting the Storage tab in the Properties window of an index.
 

  • No labels