Richard, if your query only orders or filters on a single property no index is required (GAE actually does build an index, but those are auto-generated and do not need to be specified in your index.yaml).
some queries that need indexes (assume for a moment that the proper tables are defined): db((db.building.type='house') & (db.building.built > '2010-01-27')).select() db(db.building.type='house').select(orderby=~db.building.built) glad you are enjoying web2py! christian