Hi Jeff,

I'm sorry for a delayed reply. Thanks for your help. Below are my answers.

1. Is any of that data ever updated once it's been inserted into the table? If so, what is updated column-wise?

It doesn't get updated.

2. What are the current indexes that you have on the table?

Composite PK on Customer Code / Material ID / Date and Time / Site of that customer

MaterialId and dateTime ( ignore dup key is on to avoid failures while inserting from various sources. Though all four contribute to PK - if these two keys are real contributors)

3. Do you have an FKs that point at this table?

From Time dimension

From Material dimension

From site (Customer and site together referred from this table)

4. This is one table with 500 million rows, correct?

Yes

5. What do you normally query by in this table?

Material Id and DateTime

Thanks and Regards,

Ami