Re: Index Not being used.

[Greg Mundt]

'pos_ord_headers', 'CREATE TABLE `pos_ord_headers` (\n `ORD_ID` varchar(20) COLLATE ascii_bin NOT NULL DEFAULT \'\',\n `ORD_Date` date NOT NULL DEFAULT \'0000-00-00\',\n `ORD_Time` time NOT NULL DEFAULT \'00:00:00\',\n `ORD_Store` varchar(4) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_Register` varchar(15) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_Whse` char(2) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_User_ID` varchar(10) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_User_Name` varchar(30) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_Merch_Amt` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Disc_Amt` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Disc_Pcnt` float(9,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Tax_Rate` float(9,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Total_Tax` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Line_Disc` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Return_Amt` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_TaxExempt_ID` varchar(10) COLLATE ascii_bin NOT NULL DEFAULT \'\',\n `ORD_Total_Tax2` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Total_Tax3` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Hour` tinyint(2) NOT NULL DEFAULT \'0\',\n `ORD_Taxable_1` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Taxable_2` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Taxable_3` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_NonTax_1` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_NonTax_2` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_NonTax_3` float(15,4) NOT NULL DEFAULT \'0.0000\',\n PRIMARY KEY (`ORD_ID`),\n KEY `Store_Date` (`ORD_Store`,`ORD_Date`),\n KEY `ORD_Date` (`ORD_Date`)\n) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin MAX_ROWS=1000000000'

'pos_ord_lines', 'CREATE TABLE `pos_ord_lines` (\n `ORD_ID` varchar(20) COLLATE ascii_bin NOT NULL DEFAULT \'\',\n `ORD_Line` char(3) COLLATE ascii_bin NOT NULL DEFAULT \'\',\n `ORD_Item` varchar(20) COLLATE ascii_bin NOT NULL DEFAULT \'\',\n `ORD_Desc` varchar(30) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_Qty` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Price` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Taxable` char(1) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_IGrp_Status` varchar(5) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_Item_Class` varchar(30) CHARACTER SET ascii NOT NULL DEFAULT \'\',\n `ORD_Disc_Amt` float(15,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Disc_Pcnt` float(9,4) NOT NULL DEFAULT \'0.0000\',\n `ORD_Sort_Item` varchar(20) COLLATE ascii_bin NOT NULL DEFAULT \'\',\n `Ord_Return_Reason` char(4) COLLATE ascii_bin NOT NULL,\n `ORD_BOGO_Discount_Code` smallint(6) NOT NULL DEFAULT \'0\',\n `ORD_BOGO_Discount_Amt` float(15,4) NOT NULL DEFAULT \'0.0000\',\n PRIMARY KEY (`ORD_ID`,`ORD_Line`),\n KEY `Items` (`ORD_Item`),\n KEY `Item_Classes` (`ORD_Item_Class`)\n) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin MAX_ROWS=1000000000'

4 GB RAM

'pos_ord_headers', 'MyISAM', '10', 'Dynamic', '19582913', '100', '1964588828', '1099511627775', '1137744896', '0', NULL, '2012-02-28 21:13:11', '2016-06-01 13:11:50', '2015-01-16 14:22:50', 'ascii_bin', NULL, 'max_rows=1000000000', ''

'pos_ord_lines', 'MyISAM', '10', 'Dynamic', '44991473', '97', '4364515596', '1099511627775', '1483320320', '0', NULL, '2012-02-08 22:29:05', '2016-06-01 13:11:55', '2012-02-08 22:40:38', 'ascii_bin', NULL, 'max_rows=1000000000', ''