All pastes #618188 Raw Edit

Which Query will execute faster?

public text v1 · immutable
·published 2007-07-13 20:08 UTC
rendered paste body
Which query will execute faster?

SELECT term_data.name FROM term_data 
INNER JOIN term_node ON term_data.tid= term_node.tid
INNER JOIN node ON term_node.nid= node.nid
WHERE node.nid = $nid and term_data.vid=$vid

OR

SELECT term_data.name FROM term_data,node 
INNER JOIN term_node ON term_data.tid= term_node.tid
WHERE term_node.nid=$nid AND node.nid =$nid AND  term_data.vid=$vid

Table structure
------------
CREATE TABLE `term_data` (
  `tid` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` longtext,
  `weight` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `vid` (`vid`)
)
CREATE TABLE `term_node` (
  `nid` int(10) unsigned NOT NULL default '0',
  `tid` int(10) unsigned NOT NULL default '0',
  KEY `nid` (`nid`),
  KEY `tid` (`tid`)
)
CREATE TABLE `node` (
  `nid` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `type` varchar(32) NOT NULL default '',
  `title` varchar(255) default NULL,
  `uid` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '1',
  `created` int(11) NOT NULL default '0',
  `changed` int(11) NOT NULL default '0',
  `comment` int(11) NOT NULL default '0',
  `promote` int(11) NOT NULL default '0',
  `moderate` int(11) NOT NULL default '0',
  `sticky` int(11) NOT NULL default '0',
  PRIMARY KEY  (`nid`,`vid`),
  UNIQUE KEY `vid` (`vid`),
  KEY `node_type` (`type`(4)),
  KEY `node_title_type` (`title`,`type`(4)),
  KEY `status` (`status`),
  KEY `uid` (`uid`),
  KEY `node_moderate` (`moderate`),
  KEY `node_promote_status` (`promote`,`status`),
  KEY `node_created` (`created`),
  KEY `node_changed` (`changed`),
  KEY `node_status_type` (`status`,`type`,`nid`),
  KEY `nid` (`nid`)
)