Outstanding. I've been looking for docs to show what keyword arguments are available for Field() -- it looks like I wasn't reading the sqlalchemy docs well enough though.
thanks, On Feb 23, 10:00 am, Erik Janssens <[EMAIL PROTECTED]> wrote: > custname = Field(Unicode, index=True) > > On Sat, 2008-02-23 at 07:37 -0800, dundeemt wrote: > > given: > > > class Foo(Entity): > > custnmbr = Field(Unicode, primary_key=True) > > custname = Field(Unicode) > > > A unique index is created for custnmbr. > > > Now an often used field for searching is the custname, but when > > searching/query by custname the database drops to a table scan because > > there is no index on custname. > > > question: > > How do I define secondary indices to optimize lookup times? What are > > these indexes called in the vernacular of sqlalchemy/elixir, because > > searching for secondary index doesn't return anything meaningful. > > > -jeff --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" 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/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
