SQL Server Performance Forum – Threads Archive
Aggregation
Hello,<br /><br />I would like to know how sql server choose the aggregates to materialize in order to optimize the performances of database ?<br />Which tools are useful for that ?<br /><br /><br />Thanks for your help<br /><br />Fred<br /><br />ps: if you know some good websites about this topic, i am interested <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />
could you explain in more detail
an example
Hello, Actually, i would like to know which tools does Sql Server 2005 have to propose choices about the aggregates to materialize in a datawarehouse.
If it is possible, i would like to know how this tools works, if not, what exactly it can propose. Hopping i am more clear … Thanks for you quick answer Fred
i am not clear at all on what you are asking are you asking about Analysis Services?
that the automatic aggregation the SQL Server relational database engine does not do automatic aggregation
but you can explicitly create indexed views with aggregates
"the SQL Server relational database engine does not do automatic aggregation
but you can explicitly create indexed views with aggregates" Is there a tool which can give advice in the choice of aggregates ?
]]>