Also ensure that any OLAP tools properly join the dimension
that controls the partiting field and properly presents that dimension as
a filter option to the user. If these two key items are not followed, you'll
end up hash scanning every partition in your table for every query
and performance will be a nightmare.