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