MySQL Forums :: General :: Advice on redundant indexing


Advanced Search

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 Christopher Watson 03/31/2009 01:57PM
Re: Advice on redundant indexing Rick James 04/02/2009 12:51AM


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.