Re: Help interpreting EXPLAIN results

[Dave S]

Sure thing ... thanks!

CREATE TABLE `transactions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ownerid` int(11) unsigned NOT NULL,
  `saledate` datetime NOT NULL,
  `regionid` int(11) unsigned NOT NULL,
  `customerid` int(11) unsigned NOT NULL,
  `productid` int(11) unsigned NOT NULL,
  `cash` int(11) unsigned NOT NULL DEFAULT '0',
  `credit` int(11) unsigned NOT NULL DEFAULT '0',
  `recipientid` int(11) unsigned NOT NULL DEFAULT '0',
  `reward` int(11) unsigned NOT NULL DEFAULT '0',
  `redeliverable` bit(1) NOT NULL DEFAULT b'1',
  `vtid` int(11) DEFAULT '1' COMMENT 'vendor transaction ID',
  PRIMARY KEY (`id`),
  KEY `IDX_STORE` (`ownerid`),
  KEY `IDX_CUSTOMER` (`customerid`),
  KEY `IDX_REGION` (`regionid`),
  KEY `IDX_RECIPIENT` (`recipientid`),
  KEY `IDX_PRODUCT` (`productid`),
  KEY `IDX_DATE` (`saledate`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8

CREATE TABLE `products` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ownerid` int(11) unsigned NOT NULL,
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `count` int(11) unsigned DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_ITEM` (`ownerid`,`name`),
  FULLTEXT KEY `IDX_FULLTEXT` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci