Re: NAME_CONST slow down the query

[Larry Ng]

mysql> SHOW CREATE TABLE udi_data.tblimx_tree_ref\G;
*************************** 1. row ***************************
Table: tblimx_tree_ref
Create Table: CREATE TABLE `tblimx_tree_ref` (
`MemberID` decimal(11,0) NOT NULL,
`SponsorID` decimal(11,0) DEFAULT NULL,
`Lft` decimal(10,0) DEFAULT NULL,
`Rgt` decimal(10,0) DEFAULT NULL,
`Cmt` varchar(20) DEFAULT NULL,
`TrkID` int(11) DEFAULT NULL,
PRIMARY KEY (`MemberID`),
KEY `SponsorID` (`SponsorID`) USING BTREE,
KEY `Rgt` (`Rgt`) USING BTREE,
KEY `Lft` (`Lft`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)