[dev] SQL updates (was Re: Redundant index in table mnemo_memos?)
Chuck Hagenbuch
chuck at horde.org
Tue Aug 22 11:17:07 PDT 2006
Quoting Duck <duck at obala.net>:
> Indexes should flow data logic. So in this case the PRIMARY KEY (ticket_id,
> ticket_owner) should be right. This will benefit even of a second database
> unique check. I will create the same index type for other tables without
> indexes.
Great, thanks. I've changed the ticket_owners one.
-chuck
--
"we are plastered to the windshield of the bus that is time." - Chris
More information about the dev
mailing list