I'm using the low-level google datastore api and I want to query by the key property and another property (let's call it category).
I need to query based on a list of keys for which I'll use the IN operator. I know that the max. number of values you can provide for the IN clause is 30.
I have 2 questions:
- Does the limit of 30 IN values apply to the key property as well?
- Do I need to create a composite index on {_key_ + category} or just on {category} for this query?
Thanks, Keyur