Creating Indices



• Define indices to improve query performance. • Staging tables typically do not require indices.
• Create indices on all columns that the ETL uses for dimensions and facts. For example:
– ROW_WIDs of dimensions and facts – INTEGRATION_ID
– DATASOURCE_NUM_ID
– Flags
• Carefully consider on which columns to put filter conditions.
• Inspect preconfigured objects for guidance.
• Register indices in the appropriate ODI model..

No comments:

Post a Comment