You don't need to define any composite indexes, it can use merge join. ---------- keakon
On Sat, Nov 13, 2010 at 5:48 PM, anatoliy <anatoliy.arteme...@gmail.com>wrote: > I have an entity with indexed property "nss" which is a collection. > > Making query like (produced via Query.toString()): > > SELECT __key__ FROM IndexRecord WHERE nss = qwe AND nss = wer AND nss > = ert AND nss = rty AND nss = tyu > > causes randomly (e.g. it works occasionally) exceptions "no matching > index found.." with indexes: > <datastore-index kind="IndexRecord" ancestor="false" source="manual"> > <property name="nss" direction="asc"/> > <property name="nss" direction="asc"/> > <property name="nss" direction="asc"/> > </datastore-index> > > <datastore-index kind="IndexRecord" ancestor="false" source="manual"> > <property name="nss" direction="asc"/> > <property name="nss" direction="asc"/> > <property name="nss" direction="asc"/> > <property name="nss" direction="asc"/> > </datastore-index> > > I expected that datastore is able to reuse same index for a property > if multiple filters specified. SDK does not generate index > declarations in the datastore-indexes-auto.xml file. > > Strange thing that running that query from console works ok: > > SELECT * FROM IndexRecord WHERE nss = 'qwe' AND nss = 'wer' AND nss = > 'ert' AND nss = 'rty' AND nss = 'tyu' AND nss = 'tydu' > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to google-appeng...@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine+unsubscr...@googlegroups.com<google-appengine%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.