PDA

View Full Version : Duplicate index? or not? or it's supposed to be?



bulbasnore
05-30-2010, 05:04 PM
Hi Brian and all you folks that are running dynamics!

I have a duplicate index (per phpmyadmin) as follows. Is this a problem? Should I drop one? If so, which one?


--
-- Table structure for table `adv_dyna_entries_pages`
--
-- Creation: May 17, 2010 at 05:20 PM
-- Last update: May 17, 2010 at 05:20 PM
--

CREATE TABLE `adv_dyna_entries_pages` (
`entryid` int(10) unsigned NOT NULL,
`title` varchar(255) NOT NULL,
`pagetext` text NOT NULL,
`pagenumber` smallint(4) unsigned NOT NULL DEFAULT '0',
`allowsmilie` smallint(3) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `entryid` (`entryid`,`pagenumber`),
FULLTEXT KEY `pagetext` (`pagetext`),
FULLTEXT KEY `pagetext_2` (`pagetext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Brian
06-01-2010, 12:09 PM
There should only be 1 index there, so it's fine to drop the 2nd one.