Best Practices for Indexes
The following best practices apply to indexes:
1) Always use all upper case characters for column
names.
2)
If
you have a foreign key column, associate the foreign key table and the join column.
3)
DAC uses
this information to identify all the related tables to be loaded when a certain
table needs to be loaded in the data warehouse.
4)
For
Teradata databases, pay attention to the Teradata Primary Index property.
■ For
Teradata databases:
– Pay
attention to the Teradata Primary Index property.
– Pay
attention to which columns need to gather statistics. Note that column
statistics are some what equivalent to
indexes.
– If
you would have had indexes that span multiple columns for other
databases, consider defining multi-column
statistics for Teradata.
■ Do
not register any columns for source system container tables.
■ Make
sure you add all the appropriate system columns. For example, all tables
should have the following:
– ROW_WID
in number format.
– INTEGRATION_ID
in varchar format.
– DATASOURCE_NUM_ID
in number format.
No comments:
Post a Comment