MySQL Forums
Forum List  »  General

Advice on redundant indexing
Posted by: Christopher Watson
Date: March 31, 2009 01:57PM

Just want someone to chime in on this:

CREATE TABLE `validation` (
`AUID` varchar(11) NOT NULL default '',
`name` varchar(40) default NULL,
`designation` varchar(8) default NULL,
`comments` varchar(80) default NULL,
PRIMARY KEY (`AUID`),
KEY `index2` (`name`),
KEY `index3` (`designation`),
KEY `indexall` (`AUID`,`name`,`designation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Do you see anything here that would give you pause, or make you scratch your head and ask "Now why are they doing that?"

TIA, my good people.

-Chris



Edited 1 time(s). Last edit at 03/31/2009 01:58PM by Christopher Watson.

Options: ReplyQuote


Subject
Written By
Posted
Advice on redundant indexing
March 31, 2009 01:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.