John Joseph Bachir
jjb at ibiblio.org
Thu May 4 18:51:56 GMT 2006
On Fri, 14 Apr 2006, John Joseph Bachir wrote:
> So, the best way to optimize retrieving arbitrary columns when selecting
> on an option_name is to make the option_name the primary key. Of course,
> this contradicts with the general guideline of making a primary key
> column as short as possible. But since this selection is by far the most
> frequent, and joins on this table are rare or non-existant, I still
> think this would be the best option.
> However I do not have extensive experience working with tables that use
> non-numeric coulmns as their primary key so perhaps I am missing
> something here.
I just came accross this really great thread that is all about primary
AFAIK the space problems with non-numeric primary keys mentioned in the
thread are only applicable to InnoDB.
More information about the wp-hackers