Partioning impact on DWH query performance

  • Hello all,

    does anyone have some kind of benchmark, experience figures or similar regarding the impact that partioning has on query performance in a data warehousing environment in SQL 2005? Does it 'always' make sense to use partioning? Is there a 'rule of thumb'?

    Thanks a lot!

    JM

  • there is no answer - or benchmark - you're asking the wrong question. Partitioning is a decision based upon scale ,architecture and application requirements. The performance, in a sense, is gained from the management of data - e.g. not one big table. In sql 2008 filtered and compressed indexes can be useful when using partitions - there are a few things to consider when using partitions though - like maintaining them.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply