http://code.google.com/appengine/docs/datastore/queriesandindexes.html
says

App Engine provides automatic indexes for the following forms of
queries:
    queries using only equality, IN and ancestor filters
    queries using only inequality filters (which can only be of a
single property)
    queries with only one sort order, ascending

however, the following query results in an entry in index.yaml

        WHERE user = :user
        ORDER BY created_at

If I clear everything out (deleting the data store, the history file
and index.yaml and restarting), there's no index.yaml entry for the
following query

        WHERE user = :user

Using "ORDER BY created_at ASC" also results in an index.yaml entry.

Why does that query with a single ascending order by require a custom
index?

Thanks,
-andy



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Google App Engine" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to