Re: best use of index and missing values

2006/4/14, Philippe Poelvoorde <[EMAIL PROTECTED]>: > Hi, > > I have one table : > CREATE TABLE `ressources_summary` ( > `res_type` tinyint(3) unsigned NOT NULL default '0', > `res_id` int(10) unsigned NOT NULL default '0', > `comment_count` smallint(5) unsigned NOT NULL default '0', > `com

best use of index and missing values

Hi, I have one table : CREATE TABLE `ressources_summary` ( `res_type` tinyint(3) unsigned NOT NULL default '0', `res_id` int(10) unsigned NOT NULL default '0', `comment_count` smallint(5) unsigned NOT NULL default '0', `comment_last_timestamp` timestamp NOT NULL default '-00-00 00:00:0