Hi,
On 10 January 2012 06:10, Jason Buberel <jason(at)altosresearch(dot)com> wrote:
> "Select median price for every zip code as of 2012-01-06" (customer exports)
> "Select median price for 94086 from 2005-01-01 through 2012-01-06" (charting
> apps)
>
> So by partitioning in one dimension we impact queries in the other.
I do not see any issue here; if all your queries contain date range
then you should partition by date.
--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)