1. A method, comprising: identifying a related collection of entities for a first partition of a table using a partition key, the table having multiple partitions, the table storing different entities with different sets of properties, each entity having a partition key that facilitates grouping items into partitions, each entity in the first partition having a same partition key value; detecting a query that seeks information from the first partition in the table, the table being arranged according to a table-entity-property organization; determining that the query is seeking to filter the first partition on a specific property other than the partition key; in response to said detecting and determining, preparing a memory with an index for the specific property associated with the query; copying the first partition in the table from a table store into the memory for filtering in the memory; and filtering the first partition on the specific property using the index, the first partition being filtered in the memory.