Of course an OLAP system has a different schema implementing a star or a snowflake structure and normally these schemas are implemented separately from each other.

I started this discussion with...

Sounds like good news!

But... as I said before indexing and performance problems are often a result of a bad database structure and can in most cases be avoided with a...

Having to drop an unique index to increase performance can be done easily with a generated script wether it's a primary key with clustered index or a unique clustered index.

However...

Hehe, expected reactions...; "Thanks for trying to move the industry forward, maybe not real world but at least academically."

Apart from doing a lot of the business analysis and designing thre...

The usage of unique indexes instead of declarative primary key constraints is just an old way of implementing entity integrity and should be avoided/forbidden if it's not for backwards code...