[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