Re: Index Question in MyISAM

2005-05-16 Thread Alec . Cawley
Dan Salzer <[EMAIL PROTECTED]> wrote on 16/05/2005 14:36:41: > I have the following table: > > > CREATE TABLE `Article_Search` ( > > `ArticleID` int(11) NOT NULL default '0', > > `Content` text NOT NULL, > > PRIMARY KEY (`ArticleID`), > > FULLTEXT KEY `Content` (`Content`) > > ) ENGINE=MyISAM DE

Index Question in MyISAM

2005-05-16 Thread Dan Salzer
I have the following table: > CREATE TABLE `Article_Search` ( > `ArticleID` int(11) NOT NULL default '0', > `Content` text NOT NULL, > PRIMARY KEY (`ArticleID`), > FULLTEXT KEY `Content` (`Content`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 This table has several million rows, but I only want t