For filters, you want to use an index, not a partition key. Indexes were not available when I published this post but they are now. Index any field that is used in a filter. The relevant information is in this post: