Advice on redundant indexing
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.
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.