I have brought up the idea of a datamart on several occasions but there seems to be a reluctance particularly from the chief architect to deviate from the DataVault model. We have a lot of PIT tables which are are supposed to be used for performance and thus for reporting purposes. However we are not meeting the necessary performance requirements.

There is still a lot of functionality to add to the data warehouse so I am hoping that some different architectural decisions can be made. One thing that is certain to everybody is that the Indexed view is clearly a temporary thing.

Thanks for the information. Will let you know how things go.