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,
KEY `index2` (`name`),
KEY `index3` (`designation`),
KEY `indexall` (`AUID`,`name`,`designation`)

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.


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

Options: ReplyQuote

Written By
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.