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 -~----------~----~----~----~------~----~------~--~---
