Databases: How to optimize performance for dimension attributes?

Published --