SQL Server 2005 Develoer

Hi,
I have been playing with the optimization settings for attributes and hierarchies.
I've set my hierarchies to FullyOptimized to test performance and so far
have not noticed any differences in having them optimized and not optimized.
The same applies to attributes. Has anyone else experiencced this or know
the reason why optimizing it didn't improve performance??

Thanks!
Brian

In general, AS2k5 has dimension attributes with the property of
AttributeHierarchyOptimizedState are set to FullyOptimized. As to why you
are not seeing any difference in performance, this often involves more than
just the dimensions - it can be really dependent on the cube design. For
example, if your dimensions attributes are relatively small in number (of
members), then you may not see any difference. Are your queries involving
more complex calculations (calculated members, cells, distinct counts, etc.)
where the index applied to a dimension attribute hierarchy (which is what
this setting is) has minimal effect? This setting is one of many that can
effect the performance of the query.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Brian Madden" <bmadden (AT) gmail (DOT) com> wrote