Problem with index, where clause and order by

Hi, assume a table as follows: CREATE TABLE Posts ( Board varchar(100) NOT NULL, Number int(11) unsigned NOT NULL auto_increment, Posted int(11) unsigned DEFAULT '0' NOT NULL, Subject text, Body text, PRIMARY KEY (Number), KEY index1 (Number, Board), KEY index2 (Board),

RE: Problem with index, where clause and order by

with index, where clause and order by Hi, assume a table as follows: CREATE TABLE Posts ( Board varchar(100) NOT NULL, Number int(11) unsigned NOT NULL auto_increment, Posted int(11) unsigned DEFAULT '0' NOT NULL, Subject text, Body text, PRIMARY KEY (Number), KEY index1

Problem with index, where clause and order by

Hi, assume a table as follows: CREATE TABLE Posts ( Board varchar(100) NOT NULL, Number int(11) unsigned NOT NULL auto_increment, Posted int(11) unsigned DEFAULT '0' NOT NULL, Subject text, Body text, PRIMARY KEY (Number), KEY index1 (Number, Board), KEY index2 (Board),